I want to the values of columns C and D be added to columms A and B, like the picture below.
I have tried count the rows of columns B, then write cells on the “B(rows)”. However,the rows was 49, more than 22. It means 49 rows including blanks(not expected).
Therefore, I don’t know how to do now.