This is my query put simply, the actual spreadsheet I want to use this on is
huge.

I have 3 columns
A - ref number
B - units requested from store a
C - units requested from store b

What I want is a formula which I can enter on a second sheet of the same
workbook which will display the reference number and units requested of only
those rows which have a value in column B, C or both, but ignore the blanks
(ie when no units have been requested). The orginal 'raw data' must remain
intact.

Hope this makes sense, any ideas?