Stacking a table with a number of data columns into a table with just one column of data

[CA_User]

Hello. I am trying to stack data from a table with the the data stored in columns going across but I want it in a vertical view. I've attached two images. One with the raw format and the 2nd with the format I want the end result to look like. The number of columns could vary by month as some months could have 5 days of data and other months, it's 15 days of data. Each day is currently in a separate column. The number of rows also differ from month to month.

I'm looking for VBA cold to stack each day on top of each other and have the "day #" be a column of it's own. I tried to record data but it doesn't work since the data set is dynamic. Could someone please help?

 

[Deek6t8]

set up pivot with rows and values as they are here then in Pivot table design select repeat all item labels, No sub-totals and Tabular format

 

[CA_User]

Thank you! I forgot about a pivot table! Here I was getting all fancy with VBA. :D

 

[Fluff]

What version of Excel are you using?

I suggest that you update your Account details (or click your user name at the top right of the forum) so helpers always know what Excel version(s) & platform(s) you are using as the best solution often varies by version. (Don’t forget to scroll down & ‘Save’)