I have a project that I really could use your help resolving. Attached is an excel file with two tabs. The tab labeled 4-10 is the way the data is created currently. The results tab is what I would like to see. This is a weekly file that is created and the column lengths are not standard week to week. Other than the length of the column everything else stays the same.
Ideally I would like a vba script that would create the tab "results" and populate as required. Instead of the days of the week being horizontal I need to get them vertically stacked with the new labels (issue date).
Much thanks all!