Hi please can someone help?
I have some raw data in a sheet, to keep it simple there are 16 questions that have been sent out and responded to by people
the data comes back with 16 rows, each row has the persons name and a different question and answer
In total I have over 2000 rows due to each question being on a different row
I need to create a front sheet that will merge these into one row, so it will have their name in column one, their answer to question 1 in column 2, answer to question 2 in column 3 etc.
The problem i have is I can't find a way to do a lookup that will look for their name and also what their response is to q1, q2 etc. I have tried using ifs, and, index match formulas but can't seem to crack this. Can anyone advise?
Bookmarks