+ Reply to Thread
Results 1 to 5 of 5

Extract data from columns that has data only

  1. #1
    Registered User
    Join Date
    10-27-2020
    Location
    USA
    MS-Off Ver
    Office 365
    Posts
    1

    Extract data from columns that has data only

    Hi Friends,

    I have a column range with some cells as blank and some cells have value. For example column range A5:A500 have some cells with data

    In the next column (i.e C5:C500), I need to pull value only from cell which has data in range A5:A500

    For example , in the attached screenshot, you will see that column - 'Complete Report' has many blank cell. So I need to pull only cell that have data in next column i.e 'Summarized Report'

    Error Screenshot.png
    Kindly advice on the formulas

    Thanks,
    VS

  2. #2
    Forum Expert
    Join Date
    10-15-2018
    Location
    MA, USA
    MS-Off Ver
    2010, 2019
    Posts
    1,578

    Re: Extract data from columns that has data only

    Welcome to the forum

    Please try in C6 copied down:
    Formula: copy to clipboard
    Please Login or Register  to view this content.
    Geoff

    Did I help significantly? If you wish, click on * Add Reputation to say thanks.
    If your problem has been resolved please select “Solved” from the Thread Tools menu

  3. #3
    Forum Guru
    Join Date
    09-10-2017
    Location
    Chippenham, England
    MS-Off Ver
    365
    Posts
    10,561

    Re: Extract data from columns that has data only

    Hi & welcome to the board.
    Another option
    Formula: copy to clipboard
    Please Login or Register  to view this content.

  4. #4
    Forum Expert
    Join Date
    10-15-2018
    Location
    MA, USA
    MS-Off Ver
    2010, 2019
    Posts
    1,578

    Re: Extract data from columns that has data only

    Isn't Office-365 wonderful! I feel increasing like a dinosaur without it

  5. #5
    Forum Moderator alansidman's Avatar
    Join Date
    02-02-2010
    Location
    Steamboat Springs
    MS-Off Ver
    MS Office 365
    Posts
    20,712

    Re: Extract data from columns that has data only

    and yet another means to the end with Power Query

    Excel 2016 (Windows) 32 bit
    A
    B
    C
    5
    Complete Repot Complete Repot
    6
    abc abc
    7
    abc_1
    8
    def
    9
    abc_1 b123
    10
    11
    def
    12
    13
    14
    15
    16
    17
    18
    b123
    Sheet: Sheet1

    Please Login or Register  to view this content.
    Power Query is a free AddIn for Excel 2010 and 2013, and is built-in functionality from Excel 2016 onwards (where it is referred to as "Get & Transform Data").

    It is a powerful yet simple way of getting, changing and using data from a broad variety of sources, creating steps which may be easily repeated and refreshed. I strongly recommend learning how to use Power Query - it's among the most powerful functionalities of Excel.

    - Follow this link to learn how to install Power Query in Excel 2010 / 2013.

    - Follow this link for an introduction to Power Query functionality.

    - Follow this link for a video which demonstrates how to use Power Query code provided.
    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. VBA to Extract data from Raw data by filtering multiple columns
    By Lianraj in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 12-06-2019, 01:32 AM
  2. [SOLVED] Match columns, and extract data in different columns
    By patko15 in forum Excel General
    Replies: 4
    Last Post: 06-01-2016, 09:35 AM
  3. [SOLVED] Extract similar data in columns and different data in another column
    By YasserKhalil in forum Excel Programming / VBA / Macros
    Replies: 13
    Last Post: 08-20-2015, 08:06 AM
  4. [SOLVED] Extract data from third column where data in two other columns match
    By redimp in forum Excel Formulas & Functions
    Replies: 8
    Last Post: 01-16-2014, 10:01 AM
  5. [SOLVED] macro needed to extract specific columns out of multiple columns with their row data
    By genetist in forum Excel Programming / VBA / Macros
    Replies: 9
    Last Post: 01-07-2014, 12:49 AM
  6. [SOLVED] Extract data from three columns
    By Jemima Sugantharani in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 04-21-2013, 09:01 AM
  7. Replies: 11
    Last Post: 12-04-2012, 02:56 AM

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