Forum Discussion

rayeverest's avatar
rayeverest
Copper Contributor
Jan 10, 2019

Combine two Excel columns without losing data

I need a way to combine two Excel columns without losing data. I would like a method which is fast and easy.
excel
Office
rayeverest's avatar
rayeverest
Copper Contributor
Jan 12, 2019

Any option I find involves loss of data.

Wyn Hopkins's avatar
Wyn Hopkins
MVP
Jan 12, 2019

If you have data in A1 to A10    and B1 to B10   then in C1 type = A1&B1 then copy this formula down.

  • rayeverest's avatar
    rayeverest
    Copper Contributor
    Jan 12, 2019

    How do I copy the file down?

    • Wyn Hopkins's avatar
      Wyn Hopkins
      MVP
      Jan 14, 2019
      Copy the formula (Ctrl + c) then select the cells where the formula needs to go and Paste (Ctrl + v)
      • rayeverest's avatar
        rayeverest
        Copper Contributor
        Jan 14, 2019

        The column and row identifiers change for each cell, so this copy/paste method will not work.

Resources