Is there an easy way of reformatting this in excel?
I'm trying to copy a table from a pdf into excel but the formatting is lost during the copy and paste.
The original table looks like:
a b c
d e f
And it pastes to:
a
b
c
d
e
f
Is there a built-in or easy way of reformatting this into the original format? i.e. get the i+3n values in column i, for increasing n.
Thanks!
Solution 1:
Sorry about that, this should do the trick.
=OFFSET($G$1,COLUMNS($G1:G1)-1+(ROWS($1:1)-1)*3,0)
