First question of many to come I'm sure.

I'm not sure if this is possible with just equations/formulas or if it enters the realm of macros/VBA so I'm putting it in general.

short of it: I have a table of data (rows are days, columns are rooms, data is usage of the room on that day) that I need to transpose then stack one above the other so they're all in a column. The goal is to have room and day in column A, usage in column B. Transposing via copy/paste transpose is easy but I'd like to get it to where I can add a line of data (a day from the computer logger) and have it all update, which is where I'm stuck.

The data's usable by itself for comparison to itself, but it does need to be in one big column to add to another table of data from another logger that records various types of usage. (ultimately, I'm comparing the data from the two loggers). I don't want to manually build a table of references because the tables in question are going to end up several hundred rows and 70+columns.

Brief, totally made up example: trnsps and stack.xlsx