View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
PRC PRC is offline
external usenet poster
 
Posts: 1
Default 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?