Hi, I need help in my attached file. i have in the file criteria named a to e. then there would be question answerable by 1-5. now i want to arrange the data in which all answers that were separated by column be in one column and that is the highlighted cells. i can do this using skip blanks but when i try it for multiple sets i am not sure it gives the right position. Thinking of this that i have 1000 sets to combine the answers in one column. Thanks
Bookmarks