This question is a follow-up to the thread located here: Auto-merge multiple transaction ledgers in Excel
The best solution was provided by Rob Henson
who suggested using a Pivot Table. Despite hearing of Pivot Tables on occasion in the past, I've never understood what they do or how to create/use them.
1) Could someone post a brief description/explanation of Pivot Tables and/or point me to a website with that info?
2) Could someone attach a simple example of a Pivot Table which accomplishes the objective described in the referenced thread