Combine multiple columns into one column with header and date in another column

[JJadams]

Attached is a workbook where the 'Raw Data' sheet changes frequently and the 'Output' sheet needs to combine multiple columns from 'Raw Data' into one continuous column. On any given day the number of columns and the number or rows can change so I need the VBA to be dynamic. I need to be able to start out with the data in 'Raw Data' and end up with the data in 'Output'. Please let me know if you need clarification. I really appreciate the help.Example.xlsx

[HSV]

Please Login or Register  to view this content.

Ps. Your worksheet "Output" is written as "Ouput" in your example.

[watersev]

hi JJadams, 2 options:

1. Button "Run": values go without empties in between as in your sample file
2. Button "Run1": values may have empties in between, more general option

[JJadams]

Thanks watersev. Option 2 works great. I would like to be able to specify specific columns (i.e. columns H,I, and J) in a specific sheet (i.e. 'Output') for the results to populate rather than it populating a new sheet everytime. How would I add that into the VBA?

[watersev]

do you mean sort of that? Press ALT+N on the sheet to output data. The sheet should have headers: Name, Date, Amount

[JJadams]

It doesn't seem to be working properly if there is a column header but no related data. In the attached, 'Balloon' and 'Circus' have no data but the VBA is relating data from 'Peach' to both 'Balloon' and 'Circus' anyways. Thanks again.Example (1).xlsm

[HSV]

Why I read in the comments none of my code...... not tested?

[JJadams]

HSV,

I tested your code and it worked good for the specific example that I posted but it doesn't seem to be as dynamic with blank cells and such. That is why I decided to use the code from waterserv, but I do appreciate your input.

[HSV]

JJadams,

My code works fine to me in your last posted example.

[watersev]

please check attachment, code corrected