I need some help with making a process much simpler. I'd like to take a table from an external source and turn it into full, raw data. The issue is the formatting from the source. Below is how it looks.
I need raw data with all the combinations per item in Header1that would look like this.
Is there an efficient way to do this process with a much larger table? One that could be run as a macro would be amazing. Thanks!