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
EXCEL audit the ledger?
I want to audit the excel ledger
I first use the filtration so every parts with the same material number in a line would gather together vertically.
But I want the different clusters of the same material numbers to be separated like what the attached picture shows with empty rows. How to do that?

1 Answer
- D.E.B.S.Lv 72 years agoFavorite Answer
An easy way is to do a pivot table off your data. Then you can drag and drop the column names to group them how you want without affecting your actual data.