Copying and Condensing Column Data whilst removing blank cells...

[musicman1985]

Hi...

I am creating a spreadsheet for marking/assessing call handling (I work in a call centre!). On the sheet, there are 45 categories / criteria ("greeting","own name" etc.) each with their own % of marks (7, 14 etc.) and I have an if/concatenate forumula so that if the "Greeting" criteria is marked "x" in "no", the next column shows " 'Greeting' - 7 marks" etc. Where "yes" or "n/a" have been marked "x", the concatenate/if column remains blank.

For ease of copying this into an email to be sent to the call-handler as part of their feedback, what I need to be able to do is have excel copy ALL the cells in the if/concatenate column (i.e. those that have been marked "no") into another part of the workbook BUT have all the blank rows removed.

I.e.

- "Greeting" - 7 marks
-
-
- "Own Name" - 14 marks
-
- "Customer's Name" - 10 marks

Be condensed to:

- "Greeting" - 7 marks
- "Own Name" - 14 marks
- "Customer's Name" - 10 marks

So that only the populated 'copied' cells show in the new part of the workbook.

Is this something that is possible? And if so, is there an easy way to do it?

Thanks,

PAS

[judgeh59]

can you upload an example file with all of the confidential removed?....thanks....