Announcement

Collapse
No announcement yet.

Merging 3 Columns of Data

Collapse
X
  • Filter
  • Time
  • Show
Clear All
new posts

  • Merging 3 Columns of Data

    I have 8000 lines in a Excel spreadsheet with several columns. I require to merge 3 of the columns together that all have data in them. Is there a way to do this?

    Ive tried just merging but cant because the selection contains multiple data values.

    Please advise?

    Thanks.

  • #2
    Re: Merging 3 Columns of Data

    Google would have told you how. http://www.contextures.com/xlCombine01.html
    Gareth Howells

    BSc (Hons), MBCS, MCP, MCDST, ICCE

    Any advice is given in good faith and without warranty.

    Please give reputation points if somebody has helped you.

    "For by now I could have stretched out my hand and struck you and your people with a plague that would have wiped you off the Earth." (Exodus 9:15) - I could kill you with my thumb.

    "Everything that lives and moves will be food for you." (Genesis 9:3) - For every animal you don't eat, I'm going to eat three.

    Comment


    • #3
      Re: Merging 3 Columns of Data

      Assuming data is in columns A, B & C
      Blank column D to hold the merged data
      D1 contains formula =A1 & B1 & C1
      Replicate down
      Tom Jones
      MCT, MCSE (2000:Security & 2003), MCSA:Security & Messaging, MCDBA, MCDST, MCITP(EA, EMA, SA, EDA, ES, CS), MCTS, MCP, Sec+
      PhD, MSc, FIAP, MIITT
      IT Trainer / Consultant
      Ossian Ltd
      Scotland

      ** Remember to give credit where credit is due and leave reputation points where appropriate **

      Comment


      • #4
        Re: Merging 3 Columns of Data

        Originally posted by Ossian View Post
        Assuming data is in columns A, B & C
        Blank column D to hold the merged data
        D1 contains formula =A1 & B1 & C1
        Replicate down
        Yes that has got it, thanks Ossian.

        Comment

        Working...
        X