Yahoo Answers is shutting down on May 4th, 2021 (Eastern Time) and beginning April 20th, 2021 (Eastern Time) the Yahoo Answers website will be in read-only mode. There will be no changes to other Yahoo properties or services, or your Yahoo account. You can find more information about the Yahoo Answers shutdown and how to download your data on this help page.

Trending News

Promoted
Seiy
Lv 5
Seiy asked in Computers & InternetSoftware · 8 years ago

Excel Grouping functions?

Using Excel 'Group', how can I group rows under the (column) heading Level?

Column has levels going from 1 - 5. Fist level 1 may have levels 2, 3,

Next 1 will have 2,3,4,5 etc.

I want to be able to have it collapsed by Level 1,

Then click expand and see ea. 2 under its level 1, etc.

I've seen in done before but lost my example sheet.

Update:

No not a pivot table, I can't use it for this but just in case :) I can only past a few columns too.

Thanks for responding either way

   Level Item # Item Cat Component Part Rev

  1 0001  L 722581-001 A1

   2 0001  L 722581-002 A1

    3 0001  L 722581-003

    3 0002  L 722581-004

    3 0003  L 722581-005

I have to mention, even though I very carefully tired to put this in order, it get skewed after you hit post.. ~meh~

1 Answer

Relevance
  • mickell
    8 years ago
    Favorite Answer

    You are talking about a pivot table, but I do not have enough information to explain what you are wanting to do here.

    Can you give me you first four or five rows of data?

Still have questions? Get your answers by asking now.