Menu

import simple data & re-arrange it

Search this Thread

Prev

Previous Post

Next Post

Next

#6

Report Post

Posted to microsoft.public.excel.programming

JohnB[_3_] JohnB[_3_] is offline

JohnB[_3_] is offline

external usenet poster

Posts: 3

Default

import simple data & re-arrange it

In article ,
says...
I have a text file of 40 integers in several rows, separated by commas.
I created an Excel query. I click on my query, it opens Excel, delimits
the import, and pastes this into a sheet:

1 2 3 4 5 6
7 8 9 10 11 12
13 14 15 16 17 18
19 20 21 22 23 24
25 26 27 28 29 30
31 32 33 34 36 36
37 38 39 40

I wish to turn this into a single column:

1
2
.
.
.
40

Thanks for your time, I am appreciative!

john

Reply With Quote

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

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
How to arrange data	Amin	Excel Discussion (Misc queries)	3	April 19th 10 09:48 AM
arrange data	Suri	New Users to Excel	2	November 24th 09 12:11 AM
How to Arrange Data for Chart	Karen	Charts and Charting in Excel	6	September 17th 08 06:32 PM
how to split data into columns and arrange the resulting data	jack	Excel Discussion (Misc queries)	1	November 11th 05 11:20 PM
arrange data by criteria	Jeff	New Users to Excel	4	May 24th 05 07:57 PM

All times are GMT +1. The time now is 10:02 PM.

About Us

"It's about Microsoft Excel"

Contact Us ExcelBanter forum home Privacy Statement