Access Help (or maybee Excel?)

[Da[]San]

I've got an Excel list which is 15,162 records.

Its a list of item numbers against which there are equal alternatives.

EG

1234 = 4567
1234 = 891011
1234 - 121314

What i want to do is to keep one record 1234, but then produce mutiple rows eg.
1234 = 4567,891011,121314

Any ideas

 

[Participant]

Pivot table.

 

[Da[]San]

Pivot Table isn't any good.

 

[Participant]

Really? It should be fine for it.

E.g.



Maybe I misunderstood you.