LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
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.
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Convert list to table Phelit Excel Discussion (Misc queries) 1 May 28th 08 04:09 PM
Convert a formatted table back to a list marcopolo Excel Discussion (Misc queries) 0 March 20th 08 03:08 PM
How to convert a table to list? ferdi Excel Worksheet Functions 1 March 17th 07 03:14 AM
How to convert existing Excel List into a table in Access? anna New Users to Excel 2 June 18th 06 11:57 PM
convert excel list to pivot table GI Excel Discussion (Misc queries) 0 December 6th 04 06:45 PM


All times are GMT +1. The time now is 05:29 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"