Hi there,
Nice forum: )
i have data in a column B:B that has a primary key in A:A.
This data might well have duplicates, and i want to be able to transpose this so that the data can appear on one row with multiple entries to the right for as many columns as necessary.
Kind of like this..
primary keydata
00001 123
00001 456
00001 123
00002 987
00002 357
00002 651
00005 987
00005 654
00005 987
to look like this...
00001 123 456 123
00002 987 357 651
00005 987 654 987
I would use the transpose function but i have 20,000 rows of information to deal with - can anyone recommend a script, or write a script, or have a script that may have been used in the past!?
I have searched the forums, but i could only find transposing, but not using a primary key
Help would be appreciated,
Thanks again,
Rob