As seen in the picture, the “state” column and the “state2” column are the same. What I want to do is loop whatever is written there. For example, if “state” is AK and the “state2” column is AK, other data will be written next to it and I will scrape them. Thanks!
yes, I already want to synchronize the rows If the “state” and “state2” rows are equal, I want to print the other data next to it. And I want to delete the remaining data and create a plain table with only 7 rows
Could you maybe provide a better view of the Original Input file before performing the comparison and the Expected Output file after the performing the comparison and the task. So that we would be able to logically identify the changes or transformation from input to output.
This would help us also to ask questions relative to the files/Data provided.
I add the data as it appears and after synchronizing the state writes and printing that data next to it, I will automate to enter this data on a website.