Joining Columns one below the other

Is there a reason why you can't just cut and paste?

Ah, I should have clarified that. This is only an example, Frasterist. I have 8300 columns of data.

Hi

Assumes that your data starts in row 1, and every column will always have an entry in row 1.

Please Login or Register  to view this content.

rylo

Rylo,

You the man!
Thanks a lot.

Cheers,
Harsh.

Hi Rylo,

A quick follow-up question.
Because of the huge file, excel crashes if I run the code for all 8000 lines.
So, what variable do I change so that it can copy a 1000 columns per execution?

Cheers,
Harsh.

Hi

try something like

Please Login or Register  to view this content.

rylo

This works perfect! Thanks Rylo.

Hi there does this exclude duplicates if occur?
I mean if Column B has an entry exists in Column C, would it apear?
If Yes how not to have duplicates in the result column

Thanks

firas

Welcome to the Forum.

Unfortunately your post does not comply with Rule 2 of our Forum RULES. Do not post a question in the thread of another member -- start your own thread.

If you feel an existing thread is particularly relevant to your need, provide a link to the other thread in your new thread.

Old threads are often only monitored by the original participants. New threads not only open you up to all possible participants again, they typically get faster response, too.

rylo