Hello there,
I would like to ask for help on how I can add the new output I got back to the rest of the original dataset. The data I have includes the account name and account codes together in the same column and I managed to separate them out into their own columns so the new outcome that I got consist of two columns (Name and Code).
However, I would have to join these two columns back to the rest of the dataset which contains the description and balances of these accounts. The table below shows the table that I would need to achieve and the images attached are the original dataset and the new outcome I got.
Would appreciate any tips on how I can achieve the end data set. Thanks a lot!
Code | Name | Description | Debit | Credit | Balance |
0102-001-00 | CASH-UB-COLLATERAL | CASH-UB-COLLATERAL | 450763.33 | 0 | 450763.33 |
12/12/ TXFR TO OP | 0 | 450763.33 | 0 | ||
PERIOD 12 ACTIVITY | 450763.33 | 450763.33 | 0 | ||
0103-000-00 | CASH-UB-PAYROLL | PAJE - 2016 Year-end Ad | 0 | 3661.15 | 0 |
Did you ever figure this out? Are you trying to replace the data in the original or just add it to the bottom?