Get instant live expert help on I need help with collapse columns in excel
“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 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 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 would like for extra lines to collapse on first sheet under item descriptions once you are finished making your selections and moving on to make selections in the next main item descriptions area
Solved by E. B. in 29 mins