I have a column in an Excel table that is a concatenation of several columns all within the same row. For Example A2= Ron Smith, 456763, US. B2=US. C2=Ron Smith. D2=37.
After concatenation is made the column is transformed to an all text value. The file is converted in CSV to process. But then in some cases there has been data shift. So before loading the file it is required to verify that the data contained in A2 matches B2, C2 and D2 instead of A4, C5, D3.
Solved by T. S. in 24 mins