If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
moving multiple data in a cell to other columns
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? |
#2
|
|||
|
|||
moving multiple data in a cell to other columns
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 wrote: 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? |
Thread Tools | |
Display Modes | |
|
|