How do I consolidate some cells in a column in Excel?
 

I am trying to copy data in a column from one worksheet to another in the
same workbook, However I only want the data that meets a certain criteria. I
would like the data that I retrieve to be consolidated instead of showing
empty cells in bewtween. How do I do this?

How do I consolidate some cells in a column in Excel?
 

Hi Petester,

1. "Autofilter" option in "DATA-Filter" menu will filter data based on the
specified conditions (including non-zero),

2. Select the filtered data, goto the required sheet and right-click on the
required cell and use "Paste Special" option and select values then press
"OK".

With kind regards,
NAVEEN

"Petester" wrote:

I am trying to copy data in a column from one worksheet to another in the
same workbook, However I only want the data that meets a certain criteria. I
would like the data that I retrieve to be consolidated instead of showing
empty cells in bewtween. How do I do this?