Alter Solution of a thread to " Concatenate Data" solved by MickG

[capson]

I need to Concatenate mulipe discontinuous columns, these columns are constantly changing, so in one project it might be
Columns a, e, g, k, l

And in another
Columns g,k,l,o,aa

There might be a lot of data 100,00 rows so a fast solution is desirable, I found this Here: http://www.excelforum.com/excel-prog...te-tables.html

And a solution to the thread by @MickG and altered it to Concatenate the first two rows but how to generalize it to Concatenate mulipe discontinuous columns?

Thanks

Please Login or Register  to view this content.

[AB33]

Please Login or Register  to view this content.

Concatenates columns 2 and 3, using column A as a key.
If you have a single key, you can expand the columns by changing the offset columns.

[jindon]

I see no reason to use Dictionary....
Select Column(s) that you want to concatenate.
It will only concatenate when selected column has value.

Please Login or Register  to view this content.

[capson]

jindon thank you for the responce,

I tried your code on 4 columns of 9000 rows and it exacuted but the code never completed its action even after 30 minutes

[jindon]

You must be selecting whole column....

Try select one cell in a column

like
A1:D1
A1,C1,F1:G1.... Holding down Ctrl key

[capson]

I uploaded a file with just a few rows to show how the concatenating is working.

The range was [B2:C12]

Please Login or Register  to view this content.

I get for the first cell of the concatenated Colunm

Please Login or Register  to view this content.

[jindon]

See my previous post.

Select only one cell a column...

[capson]

jindon pardon me I did not understand, I got it now, thank you

[jindon]

No problem and thanks for the rep.