Get instant live expert help on I need help with excel collapse columns

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

Post your problem and you’ll get expert help in seconds.

Our professional experts are available now. Your privacy is guaranteed.

Here are some problems that our users have asked and received explanations on

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