View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
scott scott is offline
external usenet poster
 
Posts: 577
Default How do I convert a table into a list in excel?

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.