How to append data from two different columns in an excel and write it in an existing blank column?
I have downloaded an ExcelSheet from SAP and processed it further. The current state is as follows:
where the First column only have the columnName (LIFNRERNAM) and I need to append the data from the 4th column (columnName: LIFNR) and 3rd column (columnName: ERNAM) and set it as the content of the first column (columnName: LIFNRERNAM)
Can someone help me out with an approach?
PS: In one of the previous steps I have added the blank column setting the columnNames appending 2 other columnNames