Combining data in multiple columns(all columns have same length)into one column

Hello Folks ,

This is the problem. I have data in about 650 columns like so

1 2 3 .....................................650
0.00 0.00 0.00
0.00 0.00 0.00
0.00 0.00 1.00
0.79 1.00 0.00
0.00 0.00 0.00
0.00 0.00 0.00
0.00 0.00 0.00
0.00 0.00 0.00
0.00 0.00 0.00
0.00 0.00 0.00
0.00 0.00 0.00
0.00 0.00 8.00
0.00 0 4.01
0.00 0 0
0.00 0 0
0.00 0 2
0.00 0 0
0.00 0.49 0
0.00 0 0
2.00 0 1
0.00 0 0
0.00 0 0
0.00 0 0
0.00 0 0

And I want it to be like so in a (new) one column like so


Data Point
0.00 1
0.00 1
0.00 1
0.79 1
0.00 1
0.00 1
0.00 1
0.00 1
0.00 1
0.00 1
0.00 1
0.00 1
0.00 1
0.00 1
0.00 1
0.00 1
0.00 1
0.00 1
0.00 1
2.00 1
0.00 1
0.00 1
0.00 1
0.00 1
0.00 2
0.00 2
0.00 2
1.00 2
0.00 2
0.00 2
0.00 2
0.00 2
0.00 2
0.00 2
0.00 2
0.00 2
0 2
0 2
0 2
0 2
0 2
0.490 2
0 2
0 2
0 2
0 2
0 2
0 2
0.00 3
0.00 3
1.00 3
0.00 3
0.00 3
0.00 3
0.00 3
0.00 3
0.00 3
0.00 3
0.00 3
8.00 3
4.016 3
0 3
0 3
2 3
0 3
0 3
0 3
1 3
0 3
0 3
0 3
0 3

So the data in the new column should start with data from column 1 and end with column 650 . Any help is highly appreciated.

hi Nzi..

I couldn't understand what you want to do with the data...
try to elaborate.. with a small example.
or an excel file...


Don't forget to click *

Sorry about the confusion. I cannot attach the original file because it is too large. But I am attaching an example file to illustrate the problem. Hopefully this will explain the issue better.

Maybe?

Please Login or Register  to view this content.

Thank you so much Kaper, I am trying your solution out now.

Thanks a lot John H. Davis. The code almost works. But I do not want the column headers i.e. 1 2 3 4 etc in the new single column. Any way around that ?

Kaper after messing your code a bit it is now working perfectly! Thank you so much ! I really appreciate it!

Which rows contain your headers? As it stands it copies from row 2 down.

John H. Davis, thank you again for your quick reply. I ran the code and it seems it is missing the first row of every column except the first one so when I ran the code on this ( starting at A1) data

a d g j
b e h k
c f i l

I get

a
b
c
e
f
h
i
k
l

d g and h gets lost.

John H. Davis, thank you again for your quick reply. I ran the code and it seems it is missing the first row of every column except the first one so when I ran the code on this ( starting at A1) data

a d g j
b e h k
c f i l

I get

a
b
c
e
f
h
i
k
l

d g and h gets lost.

You said you didn't want the Column headers (Post #7). It assumes you have a Column Header in row 1? If you want to pick up row 1 data then change this:

Please Login or Register  to view this content.

to this:

Please Login or Register  to view this content.

Got the solution...
Check the attached file...

Read the formula carefully..
its purely mathematical...
and only one of its kind..( I hope so...)


Don't forget to click *

Simply drag down both the formulas to include other columns in the result..


Regards
Vikas Gautam

Another using an array..

Please Login or Register  to view this content.

John Davis this work perfectly! Thanks a million!

This works as well! Fantastic!

Vikas_Gautam thank you for your help as well. I have not tried it out yet.But I am sure it will work!

You're welcome. Glad to help out and thanks for the feedback. Please mark this thread as solved.