I am trying to use the IF function to transpose the data in a column of one sheet into a row of another sheet (See attached example) The formula I'm using on the 'Qualifications' sheet in cells B2:H2 is the one I am having trouble with. For some reason, it's only grabbing the data in cell A2 of the 'Shifts' sheet. What am I doing wrong?
Bookmarks