Copy non-blank cells

jeffingle

New Member
Joined
Mar 31, 2016
Messages
2
I have the results from a form in a series of columns with each row being a unique form submission. There are a series of optional comment columns. I would like to copy the non-blank cells from the response sheet to a summary sheet with each comment on a unique line for ease of reading.
 

Some videos you may like

Excel Facts

Control Word Wrap
Press Alt+Enter to move to a new row in a cell. Lets you control where the words wrap.

Watch MrExcel Video

Forum statistics

Threads
1,095,430
Messages
5,444,408
Members
405,280
Latest member
Galliganr0

This Week's Hot Topics

Top