| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Moving data from row to columns | New Users to Excel | |||
| Moving data between columns | Excel Discussion (Misc queries) | |||
| How do I stop the TAB from moving over multiple columns | Excel Discussion (Misc queries) | |||
| .csv file Multiple columns of data in single Cell | Excel Discussion (Misc queries) | |||
| IF statements and moving data to different columns | Excel Worksheet Functions | |||
Linear Mode
