| Home |
| Search |
| Today's Posts |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Changing Columns to Rows
Sorry, use this instead:
=INDIRECT("A" & ROW()*3-4+COLUMN()) -- Gary''s Student - gsnu200752 "MEAD5432" wrote: I have a column of information. How can I move the data from the a cell in the column into a cell in a row? For instance: Currently Steve Smith 1 some road some town, CA, 555555 John Anderson 2 some blvd this town, NY, 555555 John Doe 3 this pkwy where, TX, 555555 What I want Steve Smith 1 some road some town, CA 55555 John Anderson 2 some blvd this town, NY, 555555 John Doe 3 this pkway where, TX, 555555 Any help would be appreciated. Thanks. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Changing from Rows to Columns | Excel Discussion (Misc queries) | |||
| Changing Rows into Columns | Excel Discussion (Misc queries) | |||
| Changing columns into rows | Excel Discussion (Misc queries) | |||
| Changing Columns to Rows | Excel Discussion (Misc queries) | |||
| Changing Columns to Rows Question | Excel Discussion (Misc queries) | |||
Threaded Mode
