+ Reply to Thread
Results 1 to 2 of 2

Moving Data from Filtered list into separate columns

  1. 02-08-2023, 10:37 AM #1
    JJFletcher
    JJFletcher is offline
    Forum Contributor
    Join Date
    09-10-2008
    Location
    Phoenix, AZ
    MS-Off Ver
    Office 365
    Posts
    991

    Moving Data from Filtered list into separate columns

    Hello Everyone,

    I have a situation where I need to take data that is in a single column and that data is Filtered.

    Is it possible with Formula to extract each of the filtered data and place them in a separate column of their own?

    Any thoughts would be appreciated!

    Sample



    Regards,

    John
    Attached Files Attached Files
    Last edited by JJFletcher; 02-08-2023 at 10:56 AM.
    Reply With QuoteRegister To Reply
  2. 02-08-2023, 12:46 PM #2
    TMS
    TMS is offline
    Forum Guru TMS's Avatar
    Join Date
    07-15-2010
    Location
    The Great City of Manchester, NW England ;-)
    MS-Off Ver
    MSO 2007,2010,365
    Posts
    48,943

    Re: Moving Data from Filtered list into separate columns

    Your sample data has three columns and is unfiltered.

    Please upload a sample file that represents the problem you describe.
    Trevor Shuttleworth - Retired Excel/VBA Consultant

    I dream of a better world where chickens can cross the road without having their motives questioned

    'Being unapologetic means never having to say you're sorry' John Cooper Clarke

    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)

Similar Threads

  1. combine columns from Table and displaying filtered list from data
    By mbreese in forum Excel Charting & Pivots
    Replies: 6
    Last Post: 07-22-2018, 10:06 PM
  2. Moving to next visible row in filtered list
    By nielsskovjoergensen in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 04-10-2017, 02:44 PM
  3. [SOLVED] Need a Formula to return a list of data that matches 3 criteria in seperate columns
    By JDUBS1080 in forum Excel Formulas & Functions
    Replies: 7
    Last Post: 01-23-2013, 01:06 PM
  4. [SOLVED] Creat list using data from two seperate columns
    By twitch73 in forum Excel Programming / VBA / Macros
    Replies: 12
    Last Post: 09-28-2012, 06:54 AM
  5. From a filtered list, need to get avg of values from data on 2 other columns
    By hiro.shim in forum Excel General
    Replies: 1
    Last Post: 01-07-2012, 06:27 PM
  6. processing a long list and moving content to seperate sheets
    By tsrwebman in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 06-30-2011, 02:58 AM
  7. moving data in filtered list
    By bigred0269 in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 05-05-2009, 11:10 AM

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