Macro to copy columns and paste into one column in next blank column

Sorry if my title is confusing!

I have multiple columns of data all on the same worksheet, in my example file it's called "Data". I need them to be copied and pasted into a different worksheet, "Collection", but be formatted so that they're "stacked"
If there are blanks in the column I need those to copy over as well as the column titles. Also each time the macro is run it paste into the next empty column in the tab Collection. This way I can have an ongoing trend being created.

I have searched for the answer and come close a couple times but it's never exactly what I need. I hope you can help!!

Thanks in advance!!

Try the attached.

as an option

Please Login or Register  to view this content.

Thank you both!! Both of these codes work perfectly!!
Now hopefully when I apply it to my real file I get the same results =)

Thank you again!!!!

Just a quick question, for either of the codes. Is there a way to edit where the columns start? For example one of my sheets the columns start in column "G", and in the other it starts at column "L". Is this possible to include?

For I= 1 to LC
where 1 is column A and if you want to start at column G= 7

The code pastes in to next empty row in column A, not in to next column. It only pastes in to a single column. Your description of the thread and sample do seem to contradict to each other. Is next blank column, or next empty row as your sample shows?

I want the multiple columns to paste beneath each other like it does. But the next time I run the macro I need an entirely new column. So it'd be a history of columns.
I changed the example file to show what I mean. The numbers would be different in column "A" & "C" though in the "collection" tab because it would be new data. Just every time the macro runs it should continue to stack the columns just in a new empty column.

This code works whenever you run it, but the first empty column will be column B, not A.

This is exactly what I wanted! Thank you so much!! I'm sure pasting the format is a simple fix even I can figure out.
Thanks again, I really really appreciate it!

If you do not have formulae, you can use this line

Please Login or Register  to view this content.

perfect!!!