Repeated Column Headers
Input: An Excel file having multiple columns with repeated headers.
Download sample input file here
Goal: Setup a DataFromExcel formula that pulls the data from all the columns even when column headers have been repeated and puts it in one single place.
Hint: In the options area written by the UI of DataFromExcel.SK, change the header to header~1/3 OR header~2/3. The syntax can be read as follows: header~1/3 represents "first header among 3 such occurrences"