+ Reply to Thread
Results 1 to 4 of 4

Is there a way to copy and paste many rows of data into a single column?

  1. #1
    Registered User
    Join Date
    01-24-2013
    Location
    HELL
    MS-Off Ver
    Excel 2010
    Posts
    14

    Is there a way to copy and paste many rows of data into a single column?

    I have many rows of data that I want to paste in one single column vertically. I tried using transpose, but it copies and pastes all the items into multiple columns. I just want all data in one column.

    is there a shortcut for this?

  2. #2
    Registered User
    Join Date
    07-07-2009
    Location
    Orange County, California
    MS-Off Ver
    Excel 2010
    Posts
    40

    Re: Is there a way to copy and paste many rows of data into a single column?

    Yes, but you will need a help column.
    for example you have data from col.A thru E, and from row.1 thru 10; put a formula such as "=A1&B1&C1&D1&E1" in col.G (your help column), copy down. Next copy col.G & paste value to next column H (do this if you don't want to mess around with your original data). Good luck

  3. #3
    Forum Guru samba_ravi's Avatar
    Join Date
    07-26-2011
    Location
    Hyderabad, India
    MS-Off Ver
    Excel 2013
    Posts
    7,674

    Re: Is there a way to copy and paste many rows of data into a single column?

    Attach sample file
    Samba

    Say thanks to those who have helped you by clicking Add Reputation star.

  4. #4
    Registered User
    Join Date
    01-24-2013
    Location
    HELL
    MS-Off Ver
    Excel 2010
    Posts
    14

    Re: Is there a way to copy and paste many rows of data into a single column?

    i ended up just using a macro! macros are amazing!!!

+ 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. [SOLVED] Need VBA Macro to Copy and paste column data in blank rows and repeat through spreadsheet
    By slk1186 in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 08-07-2014, 12:50 PM
  2. Replies: 5
    Last Post: 05-25-2013, 07:12 AM
  3. Replies: 5
    Last Post: 02-07-2012, 04:55 PM
  4. Cut Mulitple Rows & paste single Column
    By Musthafa1977 in forum Excel General
    Replies: 6
    Last Post: 04-19-2011, 12:21 PM
  5. Copy Column Data and Paste Into Rows
    By moongate in forum Excel General
    Replies: 3
    Last Post: 12-11-2008, 07:51 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