Thread
:
moving multiple data in a cell to other columns
View Single Post
#
2
May 30th, 2010, 09:26 PM posted to microsoft.public.excel.worksheet.functions
Gord Dibben
external usenet poster
Posts: 20,252
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?
Gord Dibben
View Public Profile
View message headers
Find all posts by Gord Dibben
Find all threads started by Gord Dibben