I've attached a sample workbook with two pages. The purpose of the workbook is to allow me to copy/paste .csv data into the workbook, then automatically "Normalize" it on another page so that the Normalized page always has the same column headers in the same place, even if the .csv data is missing (or adding) certain columns.
The sample workbook gives you several potential .csv layouts in Sheet1 to illustrate 3 variations of these files. The Normalized page shows the layout I want so that I can do calcs on all of my .csv files automatically, without having to modify formulas or move columns around whenever the .csv files differ in their individual layouts.
I tried using HLOOKUP to "find" the matching heading (if there is one) but it is not returning the expected values. Also, I can't get it to insert a blank cell (or a "" cell) if Sheet1 is empty for that cell.
Any advice? Should I use a combination of MATCH and LOOKUP?
Thanks!
Bookmarks