I need to display a pivot table in tabular form to look just like a normal table as shown below. I need the ability to sort the table by the row labels just like one would be able to with a normal table. Is there a way to do it (VBA solution is fine too)?
e.g. In the below table when I sort by Category C, the table should be sorted by that column i.e. All B1s then all B2 and so on. Ideally, sorted ascending or descending by Sum of Cash as well within each category.
e.g. In the below table when I sort by Category C, the table should be sorted by that column i.e. All B1s then all B2 and so on. Ideally, sorted ascending or descending by Sum of Cash as well within each category.