Use =Min and =Max, or other? What would you do?

[judahtravis]

I get tables of Unit Type (# of Bedrooms), Prices, and SquareFootage ranges regularly. I need to condense this information into a table that shows units of the same time, with a minimum to maximum of price, and a minimum to maximum of SquareFeet. I've been sorting the columns for unit type, then text-to-columns to put each amount into one cell, an then using =MIN and =MAX. This takes a while.

I've attached a screenshot of the table that I'm working on, and the intend result... but:
How would you do it?

 

[judahtravis]

What Would You Do-3.jpg - Google Drive