I have a set of data 245 rows deep by 28 columns wide. I want to move each row of data into a single column where each row of data is then vertically stacked above the row below.
I can’t just use Copy,Paste,Transpose as it leaves me with a lot of manual work moving the 245 columns into one.
e.g.
from:
A B C D
1 2 3
4 5 6
7 8 9
to:
A
1
2
3
4
5
6
7
8
9
Any help on this would be much apprecicated!