moving multiple data in a cell to other columns

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?
 
G

Gord Dibben

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel Columns moving up and down on their own in a worksheet. What Goes? 2
Multiple Numbers in a cell 3
Insert a semicolon in lieu of ALT Enter 4
data validation across multiple columns 1
Splitting Text from single cell in column across multiple Columns 3
calculating moving averages.. 4
The data in a linked Excel spreadsheet column is truncated to 255 characters in an Access database 0
Showing data unigue to multiple columns in a pivot table 1

Top