Hi there,

I am looking for a method to be able to do multiple transpose function, rather than doing it seperately.

I have approximately 5000 rows of data 2 columns, that needs to be converted into 6 columns of data so hence 1000 rows. So I want to know of method of doing it all in one go rather than 1000 seperate times, as it is very time consuming.

after being converted, some rows may have only 4 or upto 6 columns of data.

Here is it looks like now:

1 - LA1
1 - LA2
1 - LA3
1 - LA4
1 - LA5
2 - LB1
2 - LB2
2 - LB3
2 - LB4
2 - LB5
3 - LC1
3 - LC2
3 - LC4
3 - LC3


I want to change it into this format:

1 LA1 LA2 LA3 LA4 LA5
2 LB1 LB2 LB3 LB4 LB5
3 LC1 LC2 LC3 LC4 LC5


I thank anyone in advanced that can help with this problem alot!

Regards

Fletchy888