Hello Excel Guru's.
I am kind of stuck and there seems to be no person I the group that knows how to solve this issue without a manual effort so I brought it to the forum. I have 600 Lines to complete.
I have attached some sample data and what I need to so is transpose the months Columns D2- O2 and have the locations A2-C2 repeat twelve times over next to each month and then repeat again for the next line. I basically need it to look like the yellow highlighted section in the attachment. Any thoughts?
Sample Data.xlsx
Bookmarks