Novice needs Expert Assistance

[SandyB57]

Hi Experts,
I tried looking through some of the threads to see if there may already be a post for what I need but some of the posts and replies are way out of my scope of Excel knowledge.

I have a spreadsheet listing 214 medications with 68 columns listing side effects the medications cause. The Xs in the row designate the side effects for that particular medication. Is there a formula that will put all the side effects marked with an X for the medication at the end of each row? I have included an example of the spreadsheet indicating what I am trying to achieve.

Thank you so much for assistance!
Sandy

 

[NARAYANK991]

Hi ,

What you want done is possible only with VBA , unless your Excel version allows the TEXTJOIN function.

Either way , unless you upload your workbook , it is unlikely that much help will be forthcoming.

Narayan

 

[SandyB57]

Thank you Narayan. I've uploaded the file.

 

[vletm]

SandyB57
There is a button in BQ-column for ReFresh that column.
Something like this?

 

[SandyB57]

SandyB57
There is a button in BQ-column for ReFresh that column.
Something like this?

Yes. How did you do that?

 

[vletm]

SandyB57
This checks row by row and
side effect by side effect
if there is 'x' marked then add side effect to BQ-column.

 

[SandyB57]

SandyB57
This checks row by row and
side effect by side effect
if there is 'x' marked then add side effect to BQ-column.

Thank you SO much!!!!