Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Moving data from row to columns
I am trying to work with a dbase of names/addresses. The dbase is arranged
in a column with name, address, zip running vertically. I want to move the info to run horizontally each column reading: name, address, state, zip, etc... Is there an easy way to build a formula that will move the data as described above? Hope so!! |
#2
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Moving data from row to columns
Are there *exactly* the same number of fields for each name?
You didn't mention city ... is city combined with the state in the same cell? In other words, does each and every entry take up the same, exact number of rows? -- Regards, RD --------------------------------------------------------------------------- Please keep all correspondence within the NewsGroup, so all may benefit ! --------------------------------------------------------------------------- "gauche8715" wrote in message ... I am trying to work with a dbase of names/addresses. The dbase is arranged in a column with name, address, zip running vertically. I want to move the info to run horizontally each column reading: name, address, state, zip, etc... Is there an easy way to build a formula that will move the data as described above? Hope so!! |
#3
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Moving data from row to columns
Hi,
Lets assume your data runs from A1:A1000 and there are 6 items of info for each person - First Name, Last Name, Street, City, State, Zip. Enter the following formula in D1 and copy it to the right to column G, and down as far as necessary. =INDEX(A$1:A$1000,6*(ROW(A1)-1)+COLUMN(A1),1) if there are only 5 entries for each person just change the 6 to 5 in the above formula. If this helps, please click the Yes button. -- Thanks, Shane Devenshire "gauche8715" wrote: I am trying to work with a dbase of names/addresses. The dbase is arranged in a column with name, address, zip running vertically. I want to move the info to run horizontally each column reading: name, address, state, zip, etc... Is there an easy way to build a formula that will move the data as described above? Hope so!! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Moving data between columns | Excel Discussion (Misc queries) | |||
Moving Columns | Excel Discussion (Misc queries) | |||
moving duplicate data in rows to columns with same name | Excel Discussion (Misc queries) | |||
Moving Columns in a Pivot | Excel Discussion (Misc queries) | |||
IF statements and moving data to different columns | Excel Worksheet Functions |