Happy 8th birthday to the Maveryx Community! Take a walk down memory lane in our birthday blog, and don't miss out on the awesome birthday present that all Maveryx Community members get to take advantage of!
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.