Have another challenge that I am hoping you might be able to help me with today.
We have large spreadsheets that have headers then the data, then another header then more data and on and on. What I need to do is to take the header on top of that group of data and bring it over to a column and fill down. You can see this easily in the example I attached to this post. The row numbers are not constant and the amount of data under each header fluxuates.
Any help would be greatly appreciated.