Sorry for the bad title, I couldn't find a better way, but: I have a sheet that shows outstanding invoices by vendor -- but each vendor has only one record per row, and I need to combine those. So, if the original is:
I need it to be:
And so on. In the past, I have copied and then pasted/transpose to do this manually, but now there are too many invoices to do that with efficiently. I cannot find a good enough string of search terms to find anything helpful -- but I'm sure there is some reasonable way to do this.
Any help would be VERY much appreciated!
Vendor | Invoice | Amount |
John | 1234 | $500.00 |
Becky | 4567 | $700 |
Bob | 4561 | $300 |
John | 4512 | $200 |
Kyle | 1231 | $100 |
Kyle | 4561 | $150 |
I need it to be:
Vendor | Invoice1 | Amount1 | Invoice2 | Amount2 |
John | 1234 | $500 | 4512 | $200 |
Becky | 4567 | $700 | ||
Kyle | 1231 | $100 | 4561 | $150 |
And so on. In the past, I have copied and then pasted/transpose to do this manually, but now there are too many invoices to do that with efficiently. I cannot find a good enough string of search terms to find anything helpful -- but I'm sure there is some reasonable way to do this.
Any help would be VERY much appreciated!