First of all I would just like to say I am a total novice compared to the people on this forum and I would really appreciate any help I can get.
I need to transpose vertical data horizontally exactly like the transpose function performs it, however I have 2400 unique ID's. Each "ID" has 150 data points (each data point in the same column but seperate row...) that need to be tranposed horizontally (in the same row different column).
Is there a way I can avoid performing the transpose 2400 times?
Bookmarks