Comparing State Column with Concatenated Country Data

Question

In the dataset, I have three columns: State, Country, and Concatenated Countries. Unfortunately, some values in the "State" column have been misplaced with those of the "Country" column. The "Concatenated Countries" column contains concatenated country names for each row. The objective of this data analysis is to compare the values in the "State" column with the corresponding entries in the "Concatenated Countries" column to identify any discrepancies and then replace them in the country.

himanshu_v_17 · Answer

Hi @ShankerV

Thanks for the reply

So in the state column, there have been entries that should have been in the country column so by comparing the values to the concatenated column if there are values present they should be swapped to the country column, or if there is another way you can suggest it will be good because we cannot just transfer the data in state column to go to the country because in some places state is correct I hope it helps .

ShankerV · Answer

Hi @himanshu_v_17

In the excel sheet attached, I see City and State column.

Country column in empty.

What is the expected output you are looking for.

Thanks in advance.

Many thanks

Shanker V

himanshu_v_17 · Answer

Hi @ShankerV

Thank You for the reply

Hereby I am attaching a sample workbook of the data.

Country_Data.xlsx