How to move the entire row 8&9(currently located at column 2) to column 1 to match with row?
@Is_celine you could do it programmatically like this. Split off the wrong Rows. Create a dictionary to look up the correct column names from the ‘good’ rows. Do a rename and then concatenate them again.
2 Likes