It is posting weird. But what I want is that if the last row is the same as the current row I want the data to be under it. If the data in the last row is different from the current row i want to to be in a different column
Hi,
I would like to be able to transpose a column of data to more than 1 row. For example I would like to be able to do the following:
From
1
1
1
1
2
2
3
3
3
3
To
1 2 3
1 2 3
1 3
1 3
Any help is greatly appreciated.