How To Group Multiple Rows?

Hoping someone has a good tip for this. I have an excel sheet with 14,035 rows of data and 466 columns of data. Many rows share a common order number or common address. What is the best excel feature to group these rows and maintain all 466 columns? I’d like a heirarchmal grouping if possible, first by order number then by address. I’ve tried Power Query, get from Table but I can’t quickly convert this much data into a table.

We have customers with multiple address booked under a single order number - order number is at the customer level. at each address there may be multiple products. I need a way to quickly answer these types of questions…

-How many customer order numbers are there?

-What % of address locations have XYZ mix of products?

-How many address locations have multiple products? and what are the products?

-What is the age of the individual products?