I have a table that repeats columns that I would like to manipulate so that the similar columns are merged with new rows created. I can visualize this in the attached Excel file where the original table is shown in "Initial Sheet" and the final results in "Intended Result". I've tried a variety of ways but don't seem to get it. Any help would be appreciated.
I was aware I couldn't have duplicate columns. The initial table actually had that and when I selected dynamic rename for the first row (the columns), it appended the numbers which I was struggle with. Your solution worked perfectly. Thanks for the time and effort.
