+ Reply to Thread
Results 1 to 3 of 3

Copy paste multiple rows into a continuing single column

  1. #1
    Registered User
    Join Date
    03-12-2015
    Location
    USA
    MS-Off Ver
    Mac 2011
    Posts
    5

    Copy paste multiple rows into a continuing single column

    Hello,

    How do I run copy paste using formula to copy multiple rows into a continuing-single-column?

    For instance:
    Source Data:

    Please Login or Register  to view this content.
    To:

    1
    A Data1
    B Data2
    C Data3
    D Data4
    E Data5
    F Data6
    G Data7
    H Data8
    I Data9
    J Data10
    K Data11
    L Data12
    Last edited by JBeaucaire; 04-06-2015 at 07:46 PM.

  2. #2
    Registered User
    Join Date
    03-20-2015
    Location
    USA
    MS-Off Ver
    2013
    Posts
    18

    Re: Copy paste multiple rows into a continuing single column

    I remember I had to do this once a long time ago. There isn't an easy way (or rather clean way) to do via formula as you're always limited to what address you put; however, you can very easily UNPIVOT your data to give the result.

    Unfortunately, I have no clue how to do UNPIVOT on a Mac; however, on Windows there are at least 2 ways to do this. Once involves using Power Query and another some keyboard shortcuts to bring the legacy Office 2003 command back. I'm sure if I Google it, I'll be able to find it.

  3. #3
    Registered User
    Join Date
    03-12-2015
    Location
    USA
    MS-Off Ver
    Mac 2011
    Posts
    5

    Re: Copy paste multiple rows into a continuing single column

    I tried record macro but that didn't work on Office for Mac. Therefore I've been looking to new ways of using formula. Somehow Office for Mac has less features than PC one.

    I would appreciate if you can google that for me and send the link then I'll try to do it from there.

+ 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. Replies: 12
    Last Post: 03-05-2016, 03:03 PM
  2. Replies: 3
    Last Post: 10-23-2014, 01:58 PM
  3. How to copy and paste into multiple rows within SAME column
    By kksf in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 06-26-2013, 06:10 PM
  4. Replies: 5
    Last Post: 05-25-2013, 07:12 AM
  5. Replies: 5
    Last Post: 02-07-2012, 04:55 PM

Tags for this Thread

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