Display succeeding column data while skipping blank cells

Hi All,

I would like to get your expert advise on how to get around this issue I am encountering.

I am trying to populate a cells so that it will lookup the value from row while skipping blank cells within that row and displaying those values in a column.

So whenever a lookup value is populated on C3, it will lookup DataSheet sheet from Column B to O and display the value on cell C6 to C8 skipping blank cells.

Thank you! Appreciate anyone's assistance on this.

Which version of excel you are using?
Do you have filter and unique functions ?

Quote:

---

Originally Posted by anish.ms

Which version of excel you are using?
Do you have filter and unique functions ?

---

I am using Excel Online, and no I do not have any filter or unique functions. The datasheet is where I dump the data I gather, I just want to be able to display the cells that are not blank regardless of how many columns there is. Hope that clarifies it?

If you have filter function in excel (2019 or 365 version), paste below formula in cell C6

Code:

---

=TRANSPOSE(FILTER(FILTER(Datasheet!B2:O5,Datasheet!A2:A5=DisplaySheet!C3),FILTER(Datasheet!B2:O5,Datasheet!A2:A5=DisplaySheet!C3)<>"","No values found"))

---

This forum is for VBA codes and the codes wont work in excel online.
You may have to check the possibility of Office Scripts in Excel on the web.
Expecting experts in this forum to comment and help you in this