Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
I have a range of data 4 col wide and 400 rows deep. I need to convert the
data into a single column to post the data into another application. Currently the data looks like this: 200 450.00 test newposting 202 3187362.58 test newposting 205 106392.58 test newposting And I need it to look like this: 200 450.00 test newposting 202 3187362.58 test newposting 205 106392.58 test newposting How can I accomplish this without creating a copy/paste nightmare. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Convert list to table | Excel Discussion (Misc queries) | |||
Convert a formatted table back to a list | Excel Discussion (Misc queries) | |||
How to convert a table to list? | Excel Worksheet Functions | |||
How to convert existing Excel List into a table in Access? | New Users to Excel | |||
convert excel list to pivot table | Excel Discussion (Misc queries) |