Hello, i am bringing a couple of simialr files to geehr but in one area thy differ crucicially; one file shows the line item age as an number, whilst the other file shows the aged of the line item by placing it within one the age bucket columns.
how can i bring the files togther so that the single column age is represented in the appropriate existing bucket columns?
| CURRENT INPUT |
| | AGE | <1day | <2days | 3-5days | 6-10days | 11-15days | >115days |
| Line item 1 | 10 | | | | | | |
| Line Item 2 | | | 1 | | | | |
| | | | | | | | |
| ENDEAVOUR |
| | AGE | <1day | <2days | 3-5days | 6-10days | 11-15days | >115days |
| Line item 1 | 10 | | | | 1 | | |
| Line Item 2 | | | 1 | | | | |
