How to combine a new output back to the rest of the original dataset?

[eey_naw]

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

[lwolfie]

Did you ever figure this out?  Are you trying to replace the data in the original or just add it to the bottom?