I have a table of datas as per attached with several rows and columns. I want to filter data on the table based on items on one column.
Can I set it up in such a way that the filter seperated and the remaining columns are filtered out. (may be using a
pivot table)
See the desired output.
(So the final output table should have one column less than the original table and the unique items of that table should be displayed on a dropdown list above the table)
THanks in advance.
Bookmarks