Caporegime
- Joined
- 13 May 2003
- Posts
- 34,562
- Location
- Warwickshire
Hi
I have an Excel report that chucks out an aged debtors from our accounting system (assume the report can't be easily modified). The report only has the customer in one cell, then lists a load of invoices, which makes analysing with pivot tables tricky as I have to manually fill down the customer in column A.
So for example, I might have:
Customer: GSK
- invoice 2323423
- invoice 4634234
- invoice 5462342
But I'd need each row to have the customer filled in. Currently I just copy paste each customer's name into the rows below, but is there a better way?
Many thanks.
I have an Excel report that chucks out an aged debtors from our accounting system (assume the report can't be easily modified). The report only has the customer in one cell, then lists a load of invoices, which makes analysing with pivot tables tricky as I have to manually fill down the customer in column A.
So for example, I might have:
Customer: GSK
- invoice 2323423
- invoice 4634234
- invoice 5462342
But I'd need each row to have the customer filled in. Currently I just copy paste each customer's name into the rows below, but is there a better way?
Many thanks.