I am summarizing a .csv export from a survey program, and part of the survey is an open-ended comment. I want to be able to use the same template, and just copy in the data from a new survey to update. However, one survey might have 3 respondents, and one might have 6. My current formula is "=CONCATENATE(C1,CHAR(10),C2,CHAR(10),C3)" where C1:C3 are the comments (and CHAR(10) gives me a line break). Is there a way to capture a variety of respondents (up to 15) without using huge string of cells, and without having additional lines if there are only a few respondents?
Dan
Bookmarks