Column Value based upon Cell (parsed)

I am using the folder data connection to bring in multiple excel workbook (specific sheet). Each one needs some basic cleanup but most importantly I need to add a column based upon the value in Row1 ...