Way to distribute one column of information into multiple colums?

**Beattie** · 03-27-2012, 12:41 PM

I know this should be an easy fix, but for some reason no one has an answer on how to help. I have a column of mixed date, both text and numbers, about 1k rows long. I am trying to sort this information into four additional columns in a progression, ie.the first item in the original column goes into the first spot in the first of the additional column, the second item is first in the "new" 2nd column, 3rd to the 3rd, 4th to the 4th, and then repeat for the rest of the original column

**Beattie** · 03-27-2012, 01:54 PM

Buller, Buller anyone

**Paul** · 03-27-2012, 02:00 PM

Hi Beattie,

We ask that you only bump your thread once per day if it is not receiving a response - and certainly not within an hour of the original post. Everyone here is a volunteer, and we do our best to get to posts as we can assist.

As for your issue, if you have data in A1:A1000, and you want the following:

A1 > B1
A2 > C1
A3 > D1
A4 > E1
A5 > B2
A6 > C2, etc.

Then in B1 put this formula and then fill right to E1, and then down as many rows as you need. (Your total # of rows in column A divided by 4, of course.)

=OFFSET($A$1,ROW(A1)*4+COLUMN(A1)-5,0)