+ Reply to Thread
Results 1 to 3 of 3

Copy column with gaps

  1. #1
    Registered User
    Join Date
    05-05-2015
    Location
    Karlstad
    MS-Off Ver
    Mac 2011
    Posts
    4

    Copy column with gaps

    Hi. I'm trying to copy the values from the column R to a new list without empty rows between the values. How can I do this without copy and paste every single value one by one?Namnlöst3.jpg

    Thank you in advance

  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
    44,054

    Re: Copy column with gaps

    It would be 10X easier if, instead of a jpg, you had attached an Excel sheet. Can you do so? You can then probably do away with the intermediate columns in their entirety.
    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
    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
    44,054

    Re: Copy column with gaps

    Never worry about it.... I mocked one up. Try this. Is R range?? Given where you are, you'' probably have to use ; in the formulas, instead of , ...
    Attached Files Attached Files

+ 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. Fill company name down column with gaps
    By kestefon in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 03-19-2013, 04:57 PM
  2. jump to first non zero value in column with gaps
    By nitwit in forum Excel - New Users/Basics
    Replies: 3
    Last Post: 02-28-2013, 11:59 AM
  3. [SOLVED] Charting Date Gaps as Gaps
    By reactant in forum Excel Charting & Pivots
    Replies: 6
    Last Post: 07-10-2012, 12:42 PM
  4. how to copy cells which gaps exist between?
    By Jared in forum Excel General
    Replies: 7
    Last Post: 07-27-2006, 10:21 AM
  5. [SOLVED] Transpose Column With Gaps to Row With No Gaps?
    By SteveC in forum Excel General
    Replies: 5
    Last Post: 06-17-2005, 08:05 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