moving multiple data in a cell to other columns

  • Thread starter Thread starter Joan in DC
  • Start date Start date
J

Joan in DC

I imported a spreadsheet. One column contains multiple data lines that I
want to put into separate columns. They are consistent in their
presentation. How do I do this?
 
Assuming column A with consistent sets of data........seven cells to a set.

Adjust the "7" in formula to suit your layout.

In B1 enter =INDEX($A:$A,(ROWS($1:1)-1)*7+COLUMNS($A:B)-1)

Copy across to H1

Select B1:H1 and copy down until you get zeros.


Gord Dibben MS Excel MVP

On Sun, 30 May 2010 12:18:01 -0700, Joan in DC <Joan in
 
Back
Top