Converting data from every second to a new column
Here's my problem:
I've got a dataset wherein every second row corresponds to the row
above it (i.e., I've only got one column).
I'd like to create two columns. Surely there must be a way to do this
using a macro or the OFFSET formula, but I haven't the faintest idea
of how to actually do it.
Help?
|