+ 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... occasionally based in Ireland.
    MS-Off Ver
    O365 (PC) V 2403
    Posts
    43,891

    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




    None of us get paid for helping you... we do this for fun. So DON'T FORGET to say "Thank You" to all who have freely given some of their time to help YOU.

    Temporary addition of accented to illustrate ongoing problem to the TT: L? fh?ile P?draig sona dhaoibh

  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... occasionally based in Ireland.
    MS-Off Ver
    O365 (PC) V 2403
    Posts
    43,891

    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. [SOLVED] 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