I have a single column in a spreadsheet COLUMN A which has a lot of consistent information
a1 = Location
a2 = type1
a7 = Location
a8 = type1
there is over 1000 records (A1-A1000)
I want to transpose these so that all of the Locations go into a column B1
B2 = Type1 B3 = Type2 B4=Type3 and B5 = Type4 for each block of 5 records in the first column.
I can highlight and copy and then transpose for each indivisual set but this is taking ages
There must be a better way !