excel headers

Question

Hi All,

this should be pretty easy to do, I just can't quite figure out how...

my data contains a few columns in excel. Column headers are generally in row 2, but some column headers are split - half in raw 1 and half in row 2. How do I get proper column headers in this case?  I need to bring column headers in one raw and then I can use dynamic rename tool I guess.

Capture.PNG

flying008 · Answer

Hi, @xariet

If you input .xlsx file, please check the option [ First Row Contains Data ], then flow below : (Use Sample tool to split header row and data row, union all at last.)