“My Excelchat expert helped me in less than 20 minutes, saving me what would have been 5 hours of work!”

How do I expand or collapse several rows under a header in Excel?

Solved by M. H. in 19 mins

I need help on pivot table formatting. how to remove table formatting in excel?

Solved by V. H. in 14 mins

I have over 50 categories that are exported from a database to excel but to make sense of them I need to get excel to collapse them into a more manageable 13! How do I get excel to do this?

Solved by A. J. in 22 mins

I need a formula so that I can collapse a table based on the value in one of the columns. Essentially, in one column there are a load of numbers, which are sometimes repeated, and what I want is to make it so that all the data is condensed so that just one of each number is shown. For example:
Gene.Symbol queryHits
MTND1P23 1
MTND2P28 2
MTND2P28 3
MTND2P28 3
MTND2P28 3
I'd like to collapse this so that the data was amalgamated as:
Gene.Symbol queryHits
MTND1P23 1
MTND2P28 2
MTND2P28 3

Solved by G. Q. in 25 mins

I need help creating a collapse/expand macro button on a pivot table example data.
Need to figure out how to recreate the pivot table

Solved by Z. U. in 25 mins