+ Reply to Thread
Results 1 to 4 of 4

Join rows of data

  1. #1
    Registered User
    Join Date
    05-14-2014
    MS-Off Ver
    Excel 2003
    Posts
    5

    Question Join rows of data

    Hi,

    We have approximately 100 rows x 200 columns of data and would like to combine the contents into one row. Is this possible without copying and pasting many times.

    eg

    1 abc dek jui kol
    2 ppo adf asd dfa

    into one row

    1 abc dek jui kol ppo adf asd dfa


    Thank you
    Attached Images Attached Images

  2. #2
    Forum Moderator Glenn Kennedy's Avatar
    Join Date
    07-08-2012
    Location
    Digital Nomad... based in Ireland
    MS-Off Ver
    µSoft Office 365. Learning Excel all over again!!
    Posts
    30,754

    Re: Join rows of data

    Do you want to combine all columns and all rows (100 X 200 = 20,000 cells) into a single cell?
    Glenn



  3. #3
    Registered User
    Join Date
    05-14-2014
    MS-Off Ver
    Excel 2003
    Posts
    5

    Re: Join rows of data

    Hi Glenn,

    We would like to retain each cell as it is, but join the beginning of row 2 to the end of row 1.

    Thanks

  4. #4
    Forum Moderator Glenn Kennedy's Avatar
    Join Date
    07-08-2012
    Location
    Digital Nomad... based in Ireland
    MS-Off Ver
    µSoft Office 365. Learning Excel all over again!!
    Posts
    30,754

    Re: Join rows of data

    OK, at least that makes sense. For a moment, I thought you were insane...

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. how do i join 3 row and skip the fourth row and repeat till the end of all 600 rows
    By excel_psychopath in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 11-28-2013, 12:55 AM
  2. [SOLVED] How to join a list of data from rows to a single cell.
    By kaknoche in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 05-24-2013, 08:05 PM
  3. [SOLVED] Excel 2010 - Macro to join 5 rows with multiple cells to one row
    By fiesty in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 03-12-2013, 09:49 PM
  4. [SOLVED] join rows?
    By SusanK in forum Excel - New Users/Basics
    Replies: 3
    Last Post: 04-21-2006, 10:55 PM
  5. New feature: Two rows join & sort together.
    By debra in forum Excel General
    Replies: 3
    Last Post: 03-10-2006, 08:20 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1