I have two worksheets, containing a list of transactions on two separate accounts (a savings account and a credit card). I want to get each row from the first two worksheets into a third so that I can build a pivot table from the consolidated data. How can I achieve that?
That is, I have 10 rows in sheet A, and 10 rows in sheet B, I want to end up with all 20 rows in another sheet C. It's not important to me what order they are in. Both source worksheets have the same format.
I've tried a few things:
- Excel's "Consolidate" feature doesn't seem to achieve this (although it's possible I'm missing something).
- Pivot table features for referencing multiple ranges have the ability for "join"-like logic, but that's not what I want either.
- Pivot table features for multiple consolidation ranges sound good, but I can't get that feature to do what I need either.
I'm using Excel 2013.
There is a significant number of very similar questions, but I haven't found a question that wants to do exactly this.
My data looks exactly like this:
Date Value Description 21/01/2016 -$43.11 Pay credit card 18/01/2016 -$180.00 Movie tickets
Date Value Description 17/01/2016 -$21.00 Video games 18/01/2016 -$18.00 Beer
Sheet C (desired output)
Date Value Description 21/01/2016 -$43.11 Pay credit card 18/01/2016 -$180.00 Movie tickets 17/01/2016 -$21.00 Video games 18/01/2016 -$18.00 Beer