Consolidating non blank cells in rows
Posted by giohess on March 27, 2001 7:37 PM
I have a spreadsheet with 20 questions by row in column A and the names of 15 people at the top of columns B thru P. The answers to the questions by each person appears in their named column in the same row as the question. Not everyone answered all the questions so I have blank cells throughout the columns. I plan on removing the names on the columns and consolidating the answers to each question without having any blank cells in between. Other than cut and paste every cell that has an answer, is there a way to move or consolidate the non-blank cells into the blank cells? Did I make any sense?