0

I have a master database that lists the company with associated products and the clinical trial phase the product is in for different diseases. I am trying to only pull in columns that have values in them from the master tab. If there are no values, that column should not show (I do not want a blank column to appear). I also want to add the column header to be included.

enter image description here

New contributor
bug17 is a new contributor to this site. Take care in asking for clarification, commenting, and answering. Check out our Code of Conduct.
1
  • What have you tried so far?
    – DavidPostill
    Commented 13 hours ago

1 Answer 1

0

You could try using the following formula:

enter image description here


=TOROW(IF(($H3=$A3)*($I3=$B$3:$B$6)*($C$3:$E$6<>""),$C$2:$E$2&" "&$C$3:$E$6,NA()),2)

You must log in to answer this question.

Not the answer you're looking for? Browse other questions tagged .