+ Reply to Thread
Results 1 to 4 of 4

Google Sheet Filter and rearrange column of sheet 1 to sheet 2 with specific filter value

  1. 01-26-2024, 02:11 AM #1
    alfie4030
    alfie4030 is offline
    Registered User
    Join Date
    09-27-2020
    Location
    philippines
    MS-Off Ver
    2007
    Posts
    29

    Google Sheet Filter and rearrange column of sheet 1 to sheet 2 with specific filter value

    Screenshot (37).pngScreenshot (36).png


    can someone help me:

    1. How can i filter the data from sheet 1 to sheet 2 showing only
    the "apple" data and rearrange the columns using google sheets?

    See attached image

    THANKS FOR THE HELP
    Last edited by alfie4030; 01-28-2024 at 08:43 PM.
    Reply With QuoteRegister To Reply
  2. 01-26-2024, 02:46 AM #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
    44,445

    Re: Filter and rearrange column of sheet 1 to sheet 2 with specific filter value

    You would use FILTER to select the Apple records and CHOOSECOLUMNS to reorder the columns.
    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
  3. 01-26-2024, 02:53 AM #3
    AliGW
    AliGW is online now
    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
    80,832

    Re: Filter and rearrange column of sheet 1 to sheet 2 with specific filter value

    Please update your forum profile to GoogleSheets.

    CHOOSECOLS is the name of the function that Trevor is referring to.

    =CHOOSECOLS(FILTER(A1:F10,A1:F10="Apple"),6,3,5)
    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.
    Reply With QuoteRegister To Reply
  4. 01-28-2024, 08:41 PM #4
    alfie4030
    alfie4030 is offline
    Registered User
    Join Date
    09-27-2020
    Location
    philippines
    MS-Off Ver
    2007
    Posts
    29

    Re: Filter and rearrange column of sheet 1 to sheet 2 with specific filter value

    Thank you this greatly helped. :D
    Last edited by AliGW; 01-29-2024 at 02:10 AM. Reason: Please don't quote unnecessarily - use the Quick Reply button instead.
    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. [SOLVED] Filter specific table column in excel with two criteria in another sheet
    By alinaim1357 in forum Excel Programming / VBA / Macros
    Replies: 12
    Last Post: 11-14-2021, 01:48 PM
  2. Very similar column - TEXT Filter on one sheet, NUMBER Filter on other - Why different?
    By gottajam in forum Excel General
    Replies: 3
    Last Post: 07-09-2020, 02:11 PM
  3. [SOLVED] Filter specific Text from column and copy to Target sheet
    By E5254730 in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 04-03-2020, 03:36 AM
  4. [SOLVED] Copy specific column data from one sheet to another sheet using Certain filter Criteria
    By xlhelp7 in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 02-02-2017, 12:09 AM
  5. Filter data type mismatch? Filter column of numbers from criteria on 2nd sheet w/ wildcard
    By sdl2 in forum Excel General
    Replies: 1
    Last Post: 12-12-2014, 06:46 AM
  6. generate sheet automatically on the basis of auto filter on specific column
    By tanmanoj in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 04-08-2014, 03:42 AM
  7. [SOLVED] Need: filter, paste info to new sheet, rename sheet, unfilter, hide column, filter next
    By esmithqg in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 09-18-2012, 04:49 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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1