+ Reply to Thread
Results 1 to 3 of 3

Copy multiple column and table into single row

  1. #1
    Registered User
    Join Date
    05-04-2015
    Location
    Tanzania
    MS-Off Ver
    2013
    Posts
    8

    Cool Copy multiple column and table into single row

    Hi I have a situation wherein the data is as below.

    Row 1: A B C D E F G
    Row 2: H I J K L
    Row 3: M N O P Q
    Row 4: 1 2 3 4 5 6 7
    Row 5: 8 9 10 11 12
    Row 6: 13 14 15 16 17

    Results needs to be

    Row 1 : A B C D E F G H I J K L M N O P Q
    Row 2: 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17


    Thanks for your help on this.

  2. #2
    Forum Expert NeedForExcel's Avatar
    Join Date
    03-16-2013
    Location
    Pune, India
    MS-Off Ver
    Excel 2016:2019, MS 365
    Posts
    3,873

    Re: Copy multiple column and table into single row

    Will a Row either have Only Numbers or Only Letters? Or a Row can contain both?
    Cheers!
    Deep Dave

  3. #3
    Registered User
    Join Date
    05-04-2015
    Location
    Tanzania
    MS-Off Ver
    2013
    Posts
    8

    Re: Copy multiple column and table into single row

    row 1 2 3 will haVE letters

    row 3 4 5 will have numbers only

+ 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. Copy paste multiple rows into a continuing single column
    By eronbudi in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 04-07-2015, 11:36 AM
  2. Copy data from multiple columns into a single column
    By ajith.wilson in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 02-24-2015, 07:54 AM
  3. [SOLVED] Macro to Copy Values in Single Column to a 3 Column Table
    By rlee12 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 03-04-2013, 11:22 PM
  4. Replies: 5
    Last Post: 02-07-2012, 04:55 PM
  5. copy table into a single row or column
    By pal_slg in forum Excel - New Users/Basics
    Replies: 2
    Last Post: 10-28-2011, 01:51 AM

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