Displaying multiple values based on several cell values (Sorry about the rubbish title!)

I have a report showing orders on hold, which can happen for a number of different reasons. This is an OLAP cube report so it is in a pivot table with all of the hold reasons as individual row labels.

I have been asked to make it show the hold reason in one place and if it is for multiple reasons, show them all. I can't get my head around how to do it (I may still be half asleep). I'd prefer to have it as a calculated member within the pivot table, I have an extension that allows me to do calculated measures but as my programming knowledge is limited I'm not sure if a calculated member is possible. If not then I will have to have a formula in the column next to the pivot table.

Hope my waffle makes sense!

Thanks

Sorry, Glenn, I'm totally not with it today!

The attachment columns A-D are a simplified version of my OLAP Cube report and column E is what I want the result of the formula to look like.

What I want to do in column E is look at each hold reason (in columns B-D) individually and if it says yes, put the reason in column E, or if not blank and then move on to the next one. I tried doing if statements and joining them together like this (IF(B3="Yes",B$1,""))&", "&(IF(C3="Yes",C$1,""))&", "&IF(D3="Yes",D$1,"") but it looked messy because eg. the one on hold for the first reason and the last returns "Credit limit, , Other" and the one on hold for the last reason only returns ", , Other"

Is that clearer?

Thanks

sorry i got sidetracked with another project. This worked perfectly, thank you so much!