Select column when the row value match

Hi @lin.cw.lin

There is no activity to filter the column. we have to write a logic to achieve column filtering.
If you want to use filter or linq method, then follow below approach

You can refer the below post for transposing data

Thanks
John