0

Basically I have a table with about 100 columns, and I'd like to be able to choose which of those columns I want to see, sort of how it's done with a pivot table, where you get a list of the columns but instead, I'd like the exact same table (ie no summaries and not pivoted at all) etc.

So I'd just like a "reduced" table, without having to go and hide each column manually, and then forget which columns are hidden etc.

Any way to do this? It would help tremendously!

Topographical
  • 159
  • 11
  • You can: (1) group your columns, (2) create a pivot table using the data at this 100+ cols just to select the few columns that you want or (3) create a macro to show/hide your columns. – dot.Py Mar 28 '17 at 13:00
  • Thanks! But how would you display the table as-is (without changing values etc) using the pivot table method(2)? – Topographical Mar 28 '17 at 13:05
  • You just have to select your table and define `rows = unique_identifier` and `columns = columns that you want`. The problem is when you don't wanna do any calculation with the data, then I recommend you to take a look at [this post](http://stackoverflow.com/questions/31866420/how-can-i-make-an-excel-pivot-table-value-field-not-perform-any-operation) and [this one](https://social.technet.microsoft.com/Forums/office/en-US/b1b6de6b-6b29-4113-a299-3cb3243d9a48/text-in-the-value-field-of-an-excel-pivot-table?forum=excel). – dot.Py Mar 28 '17 at 13:26

0 Answers0