Excel – Transposing information from multiple rows to columns with their respective answers

I have a file which has the column headers Full Name, Question, Answer. I need the data in such a way so that the column headers are Full Name, Question 1, Question 2 and so on. Each questions column header should have its relevant answer.

By: Abani

Leave a Reply

Your email address will not be published. Required fields are marked *