Concatenate cell values omitting blank cells

[Lonemascot]

Ok not really sure if this is possible but I'll try to describe the problem as best I can.

I have about 28 worksheets within a workbook that outlines various phases of a construction site process so that it is easier to price .eg column headers are

[table="width: 500"]
[tr]
[td]task[/td]
[td]quantity[/td]
[td]unit of measure[/td]
[/tr]
[tr]
[td]knock down 4" walls[/td]
[td]5[/td]
[td]m2[/td]
[/tr]
[tr]
[td]clear away over site[/td]
[td]10[/td]
[td]3[/td]
[/tr]
[/table]

the list of tasks is often numerous for each build stage and not always relevant to a particular project so may not have a value in the quantity column.

I want to have a specification worksheet which basically creates a written description and quantity of what I have priced for and to leave out the descriptions of things that aren't relevant. I want to have a formula that looks up the value in the quantity column and if it has a value then return the description and quantity to my worksheet. If it is blank then I want to skip it. that bit is easy. What I really want to do is concatenate all the relevant descriptions within a range into a single cell so that the cell grows to accommodate the content.

So basically I would have a heading eg Brickwork and under it there would be a cell that fills up with relevant info. below that cell I would have another heading eg roof which would also expand to fit the content. this keeps the document from having too much blank space between headings.

the reason I want this is because I want to print out my specification worksheet and give it to the customer so only want to give them the information that is relevant and not my entire workbook.

any help is much appreciated.

 

[Lonemascot]

Please help me someone. Perhaps its too hard of a question for you smarty pants!

(perhaps some reverse Psychology might work lol)