Is there a way to add a universal list to all items in a list?

Options

Hi all,

Let's say i have a list of Alphabets

A

B

C

D

E

Could I import another excel of 1, 2, 3, 4, 5 to this list Alphabets

into

A

1

2

3

4

5

B

1

2

3

4

5

C

1

2

3

4

5

D

1

2

3

4

5

E

1

2

3

4

5

Thanks

Answers

  • Dikshant
    Options

    Make a numbered list, assign display name property.

    Codes for 1,2,3 has to be like A1, A2, A3, B1, B2, B3

  • GAPER
    Options

    That's not quite what i mean sorry. Can i use two excel Let's say B & C

    to create the list with ABCDE being parent and 12345 being child

  • SriNitya
    edited March 28
    Options

    @GAPER
    You can create hierarchy list.
    Excel1 as Parent General List.
    Excel2 Child Numbered list

  • Dikshant
    edited March 28
    Options

    If you want to automate this hierarchy creation, you can create a module of cross section of Excel 1 & Excel 2

    And you can create a view like this to create the hierarchy automatically by creating an import action using this saved view.