I have two lists of data. They are both importing automatically into two separate columns into a new spreadsheet. The data changes daily and I need to import both sets into one long list. How can I do that automatically?

For instance: Empty Rooms import into column A of a new worksheet. Full Rooms import into column B of a worksheet. Each time they import, the total numbers of each spreadsheet change depending on how many are empty or full. One day, there may be 20 empty rooms and 80 full rooms. the next day there may be 21 empty rooms and 130 full rooms.

My goal is to have 1 list that has all rooms, both empty and full.