I have a list that needs to be transposed into 8 different tables depending on a variable in the name. Basically, I get sheet 1 from our data base and need to make it look like sheet 2. Some of the rows are not used at all. I think I need to use an array, but have never been taught how to use them. Any ideas, suggestions, teaching moments would be greatly appreciated.
Thanks!