I have the following excel sheets:
sheet#1 - all rows present
Row_id Var1
1
2
3
4
5
6
sheet#1 - some rows compressed/filtered (not longer visible)
Row_id Var1
1
2
4
5
sheet#2 - not compressed/filtered
Row_id Var1
1 23
2 42
4 56
5 42
sheet#1 all rows present
Row_id Var1
1 23
2 42
3
4 56
5 42
6
I want to copy the data from sheet#2 to sheet#1 with all the row_id correctly matched. sheet#2 only has those row_id that Var1 is not missing. I tried to compressed the rows in sheet#1 to get the same row_id, but after I copy and paste, the pasted entries don't go to the right place.