Thread: import simple data & re-arrange it
View Single Post
  #6   Report Post  
Posted to microsoft.public.excel.programming
JohnB[_3_] 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 QuoteReply With Quote