Closed Thread
Results 1 to 4 of 4

How to merge dynamic ranges automatically (skipping rows without any visible data)GoogleD?

  1. #1
    Registered User
    Join Date
    07-03-2010
    Location
    Lithuania
    MS-Off Ver
    Excel 2016
    Posts
    83

    How to merge dynamic ranges automatically (skipping rows without any visible data)GoogleD?

    Hello,

    I want to merge these 2 dynamic ranges A2:B and D2:E of data, but skip rows, which do not show any visible value. The amount of rows with visible data will change from time to time in these ranges.
    Can this be done automatically - only using formulas?
    merge3.PNG
    Attached Files Attached Files

  2. #2
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Retired in Ipswich, Suffolk, but grew up in Sawley, Derbyshire (England)
    MS-Off Ver
    MS 365 Subscription Insider Beta Channel v. 2404 (Windows 11 22H2 64-bit)
    Posts
    79,369

    Re: How to merge dynamic ranges automatically (skipping rows without any visible data)Goog

    Why have you opened this duplicate thread? Are you now saying that this is a Google Sheets query?
    Ali


    Enthusiastic self-taught user of MS Excel who's always learning!
    Don't forget to say "thank you" in your thread to anyone who has offered you help.
    You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.

    Forum Rules (updated August 2023): please read them here.

  3. #3
    Registered User
    Join Date
    07-03-2010
    Location
    Lithuania
    MS-Off Ver
    Excel 2016
    Posts
    83

    Re: How to merge dynamic ranges automatically (skipping rows without any visible data)Goog

    Yes, this query is actually for Google Sheets

  4. #4
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Retired in Ipswich, Suffolk, but grew up in Sawley, Derbyshire (England)
    MS-Off Ver
    MS 365 Subscription Insider Beta Channel v. 2404 (Windows 11 22H2 64-bit)
    Posts
    79,369

    Re: How to merge dynamic ranges automatically (skipping rows without any visible data)Goog

    Administrative Note:

    Welcome to the forum.

    Unfortunately, this is a duplicate thread, and you are allowed only ONE thread per issue here.

    Please see Forum Rule #5 about thread duplication.

    I am closing this thread, but you may continue here in the original thread: https://www.excelforum.com/for-other...ible-data.html

Closed Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Google Sheets: Merge dynamic ranges automatically (skipping rows without a visible data)?
    By rcurious in forum For Other Platforms(Mac, Google Docs, Mobile OS etc)
    Replies: 15
    Last Post: 06-21-2020, 09:27 AM
  2. [SOLVED] Problem with setting up dynamic ranges skipping blanks
    By lynnsong986 in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 02-10-2020, 12:27 PM
  3. How to change font size automatically based on length of text but skipping every X rows
    By mikeymeteora in forum Excel Programming / VBA / Macros
    Replies: 8
    Last Post: 08-29-2019, 04:57 AM
  4. [SOLVED] Are named ranges not automatically visible to VBA?
    By Sidewinder72 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 09-21-2018, 06:20 AM
  5. [SOLVED] vba to copy active visible sheets only to new workbook but ranges are dynamic
    By JEAN1972 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 05-22-2017, 12:48 PM
  6. Transpose Many Dynamic Ranges (vertical) to Horizontal Arrays for Mail Merge
    By jhs_626 in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 03-17-2013, 06:22 PM
  7. create a dynamic array skipping #N/A and blank rows?
    By William DeLeo in forum Excel General
    Replies: 5
    Last Post: 11-10-2010, 02:55 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