I have a spreadsheet that has figures in A1 to Z1, A2 to X2, A3, A5 to H5 to
A968, and I need all of these entries transposed to one column in the same
order as they are in the columns ie B2 to Go to A2, C2 to go to C2 etc
I can do this manually line by line which will take me forever.
I need a macro to copy each row and transpose this to the next available
cell in column A