Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Division of Data Columns?
I have an old file that is set up in three columns like so:
A C E B D F I need the data in six columns: A B C D E F in order to sort, etc. Anyone know how I can do this easily? There are about 1000 lines of data so cutting & pasting individually is out of the question. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Division of Data Columns?
Click DATA in the menu and select TEXT TO COLUMNS. The next screen asks
whether its a fixed length record or delimited, and since you did not indicate I can only assumed that it's delimited with a space as the delimiter. If that's the case, select delimited and click the NEXT command button, indicate which character separates one data element from the other and click NEXT to review how Excel is parsing the data. Click FINSIH to complete -- Kevin Backmann "Stevie" wrote: I have an old file that is set up in three columns like so: A C E B D F I need the data in six columns: A B C D E F in order to sort, etc. Anyone know how I can do this easily? There are about 1000 lines of data so cutting & pasting individually is out of the question. |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Division of Data Columns?
=OFFSET($A$1,ROWS($1:1)*2-2+MOD(COLUMNS($A:A)+1,2),INT((COLUMNS($A:A)-1)/2))
and copy across your required 6 columns and down as far as required. I am assuming that your data values continue in the following order: A C E B D F G I K H J L M O Q N P R -- David Biddulph "Stevie" wrote in message ... I have an old file that is set up in three columns like so: A C E B D F I need the data in six columns: A B C D E F in order to sort, etc. Anyone know how I can do this easily? There are about 1000 lines of data so cutting & pasting individually is out of the question. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
2 Columns total division | Excel Discussion (Misc queries) | |||
Data Validation with division | Excel Discussion (Misc queries) | |||
Need to average division of two columns based on criteria | Excel Discussion (Misc queries) | |||
Need help with division, please!!! | Excel Worksheet Functions | |||
Page Breaks--Controlling so no division of certain data | Setting up and Configuration of Excel |