Google Sheet Query 1 By Facebook || Query, Transpose, Filter, Arrey Function

2024 3:53
Synopsis
function =TRANSPOSE(QUERY(ARRAYFORMULA(SPLIT(TRANSPOSE(FILTER(B1:F1&"@"&B2:F5,A2:A5=B7)),"@")),"select ...

You Might Also Like

Google Sheets Query Function Explained 12:35
Google Sheets Query Function Explained
2021
Google Sheets - Use ARRAYFORMULA Instead of Repeating Functions 3:59
Google Sheets - Use Arrayformula Instead Of Repeating Functi...
2022
Google Sheets QUERY Function for Beginners | Step-by-Step Guide 21:47
Google Sheets Query Function For Beginners | Step-by-step Gu...
2024
How to use the QUERY formula in Google Sheets 3:26
How To Use The Query Formula In Google Sheets
2024
Google sheets - Transform columns to rows. Transpose | Lesson 20 1:13
Google Sheets - Transform Columns To Rows. Transpose | Less...
2023
Google Sheets - Filter Function Tutorial, Introduction to Logical Arrays 32:04
Google Sheets - Filter Function Tutorial, Introduction To Lo...
2019
Google Sheets - Comparing QUERY to "Regular" Functions like FILTER, SORT, UNIQUE and SORTN 24:56
Google Sheets - Comparing Query To "regular" Functions Like ...
2022
Google Sheets: Dynamic Arrays - SORTN, SPLIT, QUERY, SPARKLINE++ 14:40
Google Sheets: Dynamic Arrays - Sortn, Split, Query, Sparkli...
2021
How to FILTER Dates in Google Sheets QUERY - Master the WHERE Clause! 📅 6:33
How To Filter Dates In Google Sheets Query - Master The Wher...
2023
QUERY Function in Google Sheets - 2025 Tutorial ✏️ 14:33
Query Function In Google Sheets - 2025 Tutorial ✏️
2024
Query Function Where Clause - Google Sheet Tips And Tricks 0:19
Query Function Where Clause - Google Sheet Tips And Tricks
2025
Download Options
Choose a download method below. All links open in new tabs.
Service Features Action
SaveFrom
MP4 & MP3 • HD Quality • Browser Extension Available
Download
Security Notice: These are third-party services. We recommend using antivirus software and being cautious of pop-up ads.