Looking for some advice, is there a way (without macros) to rearrange data that has been split in the way shown below (like two columns of data but split across 2n columns, n being >1):
A1.00E5.00
B2.00
H8.00
C3.00F6.00
D4.00G7.00
Hoping to convert to this (not gaps removed if...