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.
|