Hello @Mwoody_05 ,
Here a generic way of doing the process.
What ever is the number of header it will always work the same way. The idea is to separate header and data. Transpose the header and then, based on an ID, reconcile it with the data. Then it is generic.
What you have to do from 1 case to another is just adapt the numbers of row/ column you have in the header (and then in the foloowing process). Same thing from data.
The little trick is at the very import 1st step to check the "1st row contain data" that will then generate a sort of unique ID for the column (F1, F2, F3...) which prevent you from any error if your 1st header have duplicate labels.
Hope it helps