Grouping large amounts of data

Hello all! I'm not sure if what I'm wanting is even possible to do, but I figured it didn't hurt to ask!

I have an excel spreadsheet with a ton of different sales data. It displays all orders that had a sale price of over $1000. However, it is currently a bit of a mess so I'm trying to clean it up and have it look as user friendly as possible. I've attached a sample, imagine that but much, much larger. What I'd like to do is collapse lines that show multiple products that were ordered in a single order to show an overview of the entire order, but be expandable to be able to show the details as well. I'm not sure how well that makes sense, so I'll explain a bit more.

On the sample, Rows 5 and 6 are the same order. So are Rows 7-10. Instead of displaying each of those rows, I'd like to instead show a summary row that has info about the order (Order number, Sales Amount, Bill Date, Bill Doc, Customer, Territory, Account, Unit, Zip, Period) but can be expanded to show all data.

Is that even remotely possible? With a pivot table, maybe? I just hate pivot tables.

Thanks!!

Sample Book.xlsx