Hi,
I have file where the original format has two questions per person and puts the questions & answers in two separate rows. (See rows 2 & 3 in EX 1 jpg file)
Ex 1.jpg
I need to have the questions and the answers from row 3 moved to row 2 in separate columns. (See row 2 in EX 2 jpg file)
Ex 2.jpg
Sample Data Attached
Thanks in advance for any help
Bookmarks