We live in a smallish house. My husband wanted an office for his photography business and I wanted a school room for homeschooling. Moving isn't an option for us so we decided to get creative. Our master bedroom is huge. It is about half the size of our home so we decided to add a library to one wall. I moved all our books from the living room into a corner/wall of our bedroom and created an awesome book nook. The books stay more organized because our little girls don't pull them off the shelves.
We also wanted a sewing area for our oldest daughter so we brought up the old kitchen table from our basement and put that against another wall in the bedroom. She now has a place for all her sewing items and my son has a place to build legos and no little girls can destroy his creations!
My hubby got his office. We have a huge walk in closet that we turned into his office. He is able to keep his business computer in there as well as his photography gear.
Looking at our master bedroom in a different way worked for us!