Combining two sets of data

I have two sets of data that I need to combine. In this example, I have data in G4, G6, G8, G10 and G12, i.e. in every two rows. I also have data in F5, F7, F9 and F11. How can I quickly move the data from the F column to the empty cells of G5, G7, G9 and G11. Attached is the Excel file with the situation.

Thank you for your help.

Formulas would be really easy. Here is a sample file with the numbers in column D. You only have to put the first 2 formulas in, select both cells, and drag down as far as you need.

Cell L4 formula , Drag down

Formula:

Please Login or Register  to view this content.

Just another option:

=NUMBERVALUE(TEXTJOIN("",TRUE,F4:G4))

If you didn't care about them being numbers, you could use:

=TEXTJOIN("",TRUE,F4:G4)

Originally Posted by FlameRetired

Another way without formula.

1. Select F4:F12
2. Hit F5 function key (GoTo feature)
3. Click the Special ... button
4. Click the Blanks radio button
5. Hit Enter
6. Hit Ctrl + "-" (minus key) on the numeric keypad
7. Select Shift cells left
8. Click OK

Hehe, nice one.