Meta Data in Column Name to Row
Greetings, I am in need of help scripting a multi-step process as I am unable to abstract a viable solution to achieve some data preparation work.I have time series data that comes in as several spread sheets, containing several tabs, and each tab has data with column names that contain meta data contextualizing the data.In the example below, the columns with "Descriptor" (columns 1,3 and 5) shoul...