Multi story houses in terraria

The generally accepted way is to stack rooms on top of each other, with doors leading out into a common vertical shaft of some kind.

Put the wooden platform floors out in the common areas so you can get around between the various rooms.

You want something similar to this:

Houses cannot share single tile walls either but they can share floor/ceilings as seen above.