Need to append data from multiple columns into one long column

See attached file for data. I would like to create one long column of 255,000 rows using the attached data. Basically, taking all of the data in column B and copy and pasting (or cutting and pasting) to the end of column A, then doing the same with column C at the new end of column A (around row 30). The header row can be ignored.

I thought about an INDEX formula, but didn't know how to name the range for each column efficiently and then even if the resulting formula would work.

The full data set is larger, so understanding the technique used would be helpful.

I added a few rows at the top and then used this code. Any idea on how to loop that for 365 times (or until no data exists to the right) to automate?

Please Login or Register  to view this content.