Formula to get unique list of values from multiple columns in a table

[paulma1960]

Hi,

I have a table of values that is like a basket of items, that I would like to produce of list of distinct items in the basket. I'm using Excel 365. I've tried using the UNIQUE function, but it works only on a single column, not the multiple columns I need to search.

I'll add that every row in the first column has a value, many of the rows (up to 26 of them) in the following columns are empty, but all need to be considered. I don't know if this is relevant, but the 26 columns are derived by extracting values from a comma-delimited text, so I have all the values per row in a single column source row.

Any suggestions are much appreciated. TIA. Paul

I've added an excerpt to demonstrate the source data and what I'm looking for.