Hello all,
This is a rather simple question but suprisingly couldn't find an answer thus far.

I have an excel file with several sheets. Each sheet has a lot of raw data, different variables in each sheet, though there is one (sometimes more) "key" (a product SKU for example).

All I want to accomplish is to have one excel sheet with all of the columns and variables combined.
What's easy to accomplish is to have a pivot table with all the variables - but that's not what I want. I don't want the aggregate/calculated values in a pivot table - I just want to have one sheet with all the data put together, to be analyzed somewhere else.

Can anyone help?

Thanks!