Can you replace a support wall in a house with columns and remove the wall?

I’m just wondering how that usually works in a typical house with two stories. How far apart would the columns, assuming it is possible need to be?

Also, can a bonus room, the floor of the room, above a garage easily be removed to make a two story garage?