Show all columns in a matrix with data after a slicer has been applied

[analyst10101]

I'm looking for some help in appling a slicer to a matrix. I have a matrix and when I add a slicer on the column values, I would like to display all columns which have a value for the slicer choice.

for example if this was the original table

If column 1 was selected in the slicer I would like this result (not just the column 1 values)

Many thanks

[Greg_Deckler]

@analyst10101 What does your source data look like? Can you post it was text?