Hello guys!
As the title says a I am having a problem solving this scenario. Its a large database started by another employee and now its my job to continue inserting the data.
I am putting pictures to explain it better.
1.jpg
As you can see in column J the cells are merged by 4 rows. This is the column I want to copy.
2.jpg
This is the row I want to paste to. When I try Values Transpose every each row is pasted, Excel counts the 4 merged rows not like 1 but like 4.
I fail to solve my problem even when I try to copy the formulas from data from previous days already inserted by the other employee.
Every suggestion is welcome
Bookmarks