If you want a worksheet formula solution, put this formula into cell C1:

=OFFSET($A$1,(COLUMN()-COLUMN($C4)+(ROW()-ROW(A$1))*6),0)
fill it to the right to column H and then fill the entire group down until
you've gone far enough to capture all of the data in the column ... down to
about row 240.

This just copies the data via formula; if you want to do away with the
entries in column A, start by selecting all of the cells with the formulas in
them and use Edit -- Copy followed by Edit -- Paste Special with 'Values'
ticked. After you do that, you can clear out column A.




"Its me" wrote:

Hi to all
I am a new user to Excel and I have a list of data that is in 6 lines per
record that I want to move to 6 separate columns per record - can this be
done?
The data goes from A1:A1435
Many thanks in advance
Stephen West
Gold Coast, Australia

.