VC to only show occupied column from a range

[Chris_Jeal]

Hi all,

Potential for a headache here I think…

I would like a VC to search to find which column from a range isnotblank then display the value.

For example: I have 4 columns A - D

Blank Columns A,C,D,
Occupied Columns B

The VC will then show the value in column B as the other 3 are blank.
This will save showing all four columns in a table although 3 out of the 4 would be blank.

It’s worth noting that only one of the columns can be populated in each record.

Thanks in advance.
Chris.

[Steve]

Try:

ANY(LIST([Column A], [Column B], ...) - LIST(""))

LIST([Column A], [Column B], ...) constructs a list of possible values, - LIST("") removes all blank values from the first list, leaving only non-blank values, and ANY(...) extracts the first if the remaining non-blank values.

[Lynn]

Hi @Chris_Jeal You could also CONCATENATE the columns if only one is to have a value.

[Chris_Jeal]

Thanks guys,
Will give them both a shot.

C