I have been scanning web forums for days and have not found a solution to my question. I have found similar, but unfortunately am not clever enough with Excel VBA to adapt, so I hope someone can help.
I have two columns of data which I want merged into rows (a) by survey number and (b) by time slots. The data I have is similar to:
Survey No.....Results
12345...........9am-12pm
12345...........3pm-6pm
12345...........No answer
56789...........6am-9am
56789...........12pm-3pm
56789...........6pm-8pm
56789...........10pm-12am
.
.
etc
What I want is:
Survey No......6am-9am.....9am-12pm.....12pm-3pm.....3pm-6pm.....6pm-8pm.....8pm-10pm.....10pm-12am
12345.............................9am-12pm........................3pm-6pm.....No answer
56789............6am-9am........................12pm-3pm......................6pm-8pm........................10pm-12am
AND (if it's not stretching the friendship too far) an entry of "No answer" should go into the next blank column for that survey.
I guess it doesn't actually have to repeat the times - just an indicator in the correct column would probably do!
Can anyone offer me a VBA (or other) solution please? Sorry, the columns don't display too well, so I've used dots as separators!
Bookmarks