Macro Needed to Concatenate Data in separate ROWS

Hello,


I need a simple macro that concatenate data in separate rows and put the result on sheet 2.
Please note that the rows can be more than 150000



Please see file attached (2 sheets)


THANK YOU

Hello
I have a awesome user defined function for you
Check if this helps...
Change the array to suit....

Thanks for help me....but your function doesn't works because the results have to include both two columns (written on blue on second sheet)

I think It is better a macro.




Someone can code it please?

Or:

Please Login or Register  to view this content.

Originally Posted by jindon

http://www.excelforum.com/excel-prog...ml#post3981768
Change to

Please Login or Register  to view this content.

Sorry but It doesn't appears nothing on sheet 2 with this code;
And with the previous thread code you coded, with a large file sometimes It doesn't appear nothing or It says "end of memory error"

Make in the VBEditor an active connection to "Microsoft Scripting Runtime" checking References (Tools/References).

No, I've tried another time and that code on my original file doesn't works. (...also with few rows....)



Please see this original file I've attached at this post;
I need a simple macro that put the result on sheet 2



Thanks

No, It doesn't works on large file

Someone can code a macro that is able to do this?
vba20.xlsx
(I need that It put the results on sheet 2





this is the original (cutted file) where the macro will work.
22vba.xlsx



THANKS

Originally Posted by jindon

My code are both working on your file.

It may raise the error for the bulky data, so I said post back if you get the error.

Or maybe we are talking about different EXCEL.

Please Login or Register  to view this content.

Hello,

Your code works on the test file;
But If I try the macro on the original file (larger) It doesn't appears nothing on second sheet.






thanks



thanks

Hello jindon,


Your code worked well:

Please Login or Register  to view this content.

But now I'm working with these very heavvy files (more than 150000 rows) and It says me: end of memory.


Can you make the code works for this kind of big files??







thank you VERY much