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!”
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