+ Reply to Thread
Results 1 to 3 of 3

Get values in continuous cell from a column with gaps

  1. 05-28-2012, 01:00 AM #1
    shawpnik
    shawpnik is offline
    Registered User
    Join Date
    05-28-2012
    Location
    Australia
    MS-Off Ver
    Excel 2007
    Posts
    12

    Get values in continuous cell from a column with gaps

    Hi,

    How can I put the values in a column without no gaps from a column with gaps?

    Thanks in advance.

    Please find the attached file to get an example of input and required output.

    Best regards
    Mahmud
    Attached Files Attached Files
    Reply With QuoteRegister To Reply
  2. 05-28-2012, 01:14 AM #2
    jraj1106
    jraj1106 is offline
    Valued Forum Contributor
    Join Date
    02-09-2012
    Location
    Mauritius
    MS-Off Ver
    Excel 2007
    Posts
    1,055

    Re: Get values in continuous cell from a column with gaps

    Hi

    Try this macro:

    Problem_1.xlsm
    Click *, if my suggestion helps you. Have a good day!!
    Reply With QuoteRegister To Reply
  3. 05-28-2012, 02:07 AM #3
    icestationzbra
    icestationzbra is offline
    Forum Expert icestationzbra's Avatar
    Join Date
    01-07-2004
    MS-Off Ver
    2007, 2010
    Posts
    1,421

    Re: Get values in continuous cell from a column with gaps

    if you want a formulaic method, put this CSE formula in F7:

    Please Login or Register  to view this content.
    and drag-fill down...
    - i.s.z -
    CSE, aka Array aka { }, formulae are confirmed with CONTROL+SHIFT+ENTER.
    Replace commas ( , ) with semicolons ( ; ) in formulae, if your locale setting demands.
    All good ideas are courtesy resources from this forum as well as others around the web.
    - e.o.m -
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

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

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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1