Macro Needed to Concatenate Data in separate ROWS

Originally Posted by 823

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"

It should populate the result in the same sheet.

Check 2 or 3 columns to the right of your original data.

If it raise the error, post back.