I have a code developed in re framework. now i am doing small modifications to code in between. I am getting data from 3 different tabs and merging into one data table to compare with another data table further. when merging i have a issue with list price column like in the picture attached, 2 tabs are giving listprice columns correctly according to the further code. But the 3rd tab is giving space in List Price which is throwing the bot off in further code and giving exceptions.
I dont want to change the further code as it contains lot of validations and also big. I want to fix at the columns name in data table, how to merge both columns ? can anyone help me. Thanks