How to Get a UNIQUE List from Many Columns Using FLATTEN in Google Sheets

Leila Gharani β€’ July 20, 2021
Video Thumbnail
Leila Gharani Logo

Leila Gharani

View Channel

About

Excel. Power Query. Copilot. ChatGPT. Power BI. PowerPoint. You use them every day to automate Excel and your work - so why not actually master them? I’ll show you how to: βœ”οΈAutomate the stuff that drives you nuts βœ”οΈ Spend less time on grunt work, more time on wow work βœ”οΈ Build reports that look good AND actually make sense What You’ll Learn Here: βœ”οΈ Excel, Power BI, PowerPoint, VBA, Google Sheets & more βœ”οΈ AI-powered Excel & the future of work βœ”οΈ Data & finance skills that give you an edge I don’t just teach this stuff - I use it daily. My goal? To help you think differently about the tools you already have, so you can work faster, and with confidence. πŸŽ“ My background: MA in economics / Economist / Business Consultant / Accounting Systems Expert / Oracle & SAP implementations (for Finance) / Teacher & Microsoft MVP πŸ’‘ 400,000+ professionals have taken my courses at XelPlus - because working smarter just makes sense. Join here πŸ‘‰ https://www.xelplus.com/courses/

You May Also Like

Upgrade Your Gear Today

AI-recommended products based on this video

Loading...
tomtoc 360 Protective Laptop Sleeve for 15.6 Inch Acer Aspire 1/3/5 15 Slim Laptop, 15.6-16 Inch ASUS Strix G16/G15, HP Pavilion 15, Lenovo Ideapad 3 Laptop, 15.6 Inch Dell Samsung Notebook Ultrabook

tomtoc 360 Protective Laptop Sleeve for 15.6 Inch Acer Aspire 1/3/5 15 Slim Laptop, 15.6-16 Inch ASUS Strix G16/G15, HP Pavilion 15, Lenovo Ideapad 3 Laptop, 15.6 Inch Dell Samsung Notebook Ultrabook

(3,132)
$37.59
FREE delivery Sat, Jun 21
Loading...
koolehaoda L Shape Camera Bracket, Video Vertical Shooting Quick Release Plate L Stand Arca Swiss Compatible for Tripod Head Ballhead DSLR Camera

koolehaoda L Shape Camera Bracket, Video Vertical Shooting Quick Release Plate L Stand Arca Swiss Compatible for Tripod Head Ballhead DSLR Camera

(87)
$23.98
FREE delivery Thu, Jun 19 on your first order
Loading...
NEEWER CA076 Zfc Handgrip L Shape Grip for Nikon Z fc, Ultra Thin Retro Formfitting Camera Mounting Baseplate with Handle/Brass Shutter Button, Compatible with Arca Swiss Tripod Fluid Head, Black

NEEWER CA076 Zfc Handgrip L Shape Grip for Nikon Z fc, Ultra Thin Retro Formfitting Camera Mounting Baseplate with Handle/Brass Shutter Button, Compatible with Arca Swiss Tripod Fluid Head, Black

(175)
$33.99
FREE delivery Thu, Jun 19 on your first order
Loading...
SmallRig FX3 / FX30 HawkLock Quick Release Camera Cage Kit for Sony with Cable Clamp, Bulit-in QR Cold Shoe NATO Rail/QR Plate for Arca, Modular Design Compatible with Original XLR Handle - 4770

SmallRig FX3 / FX30 HawkLock Quick Release Camera Cage Kit for Sony with Cable Clamp, Bulit-in QR Cold Shoe NATO Rail/QR Plate for Arca, Modular Design Compatible with Original XLR Handle - 4770

(35)
$124.94
FREE delivery Thu, Jun 19
Loading...
SmallRig ZV-E1 Camera Baseplate for Sony ZV-E1, Built-in Cold Shoe Mount and QR Plate (for Arca) Quick Switch Between Tripod and Stabilizer for DJI RS 2 / RSC 2 / RS 3 / RS 3 Pro - 4314

SmallRig ZV-E1 Camera Baseplate for Sony ZV-E1, Built-in Cold Shoe Mount and QR Plate (for Arca) Quick Switch Between Tripod and Stabilizer for DJI RS 2 / RSC 2 / RS 3 / RS 3 Pro - 4314

(3)
$44.99
FREE delivery Thu, Jun 19
Loading...
TRMFUSA Packing Cubes for Suitcases, TRMFUSA 10 Pcs Packing Organizers, Luggage Organizers with Laundry Bags/Shoe Bag/Toiletry Bag (Gray)

TRMFUSA Packing Cubes for Suitcases, TRMFUSA 10 Pcs Packing Organizers, Luggage Organizers with Laundry Bags/Shoe Bag/Toiletry Bag (Gray)

(20)
$25.99
FREE delivery Sat, Jun 14 on your first order
Loading...
DIMJ Compression Packing Cubes Travel Organizer,Travel Packing Cubes Compressible for Carry on Luggage Lightweight Expandable Luggage Travel Accessories (8 Set-Beige)

DIMJ Compression Packing Cubes Travel Organizer,Travel Packing Cubes Compressible for Carry on Luggage Lightweight Expandable Luggage Travel Accessories (8 Set-Beige)

(146)
$26.99
FREE delivery Sat, Jun 14 on your first order
50+ bought in past month
Loading...
NICOSHOW 6 Set Compression Packing Cubes, Compressible Travel Packing Cubes Travel Essentials, Luggage Organizers for Carry-on Suitcase, Grey OEKO-TEX STANDARD 100

NICOSHOW 6 Set Compression Packing Cubes, Compressible Travel Packing Cubes Travel Essentials, Luggage Organizers for Carry-on Suitcase, Grey OEKO-TEX STANDARD 100

(1,445)
$27.99
1K+ bought in past month
Loading...
BAGAIL 8 Set Packing Cubes Luggage Packing Organizers for Travel Accessories Global Recycled Standard
Best Seller

BAGAIL 8 Set Packing Cubes Luggage Packing Organizers for Travel Accessories Global Recycled Standard

(37,758)
$29.99
FREE delivery Sat, Jun 14 on your first order
300+ bought in past month
Loading...
VYLEE Universal International Power Travel Plug Adapter, 5 in 1 European Travel Plug Adapter W/ 3.5A 2xUSB-A and 2xUSB C Wall Charger and Worldwide AC Outlet for Europe USA UK AUS Asia

VYLEE Universal International Power Travel Plug Adapter, 5 in 1 European Travel Plug Adapter W/ 3.5A 2xUSB-A and 2xUSB C Wall Charger and Worldwide AC Outlet for Europe USA UK AUS Asia

(1,928)
$26.99
Prime
4K+ bought in past month
Loading...
Hand Warmers 2 Pack, 14000mAh Rechargeable Hand Warmers, Electric Hand Warmer Reusable, Portable Power Bank USB Hand Warmers 4 Levels 8 Heating, Gifts for Raynauds Ski Golf Camping

Hand Warmers 2 Pack, 14000mAh Rechargeable Hand Warmers, Electric Hand Warmer Reusable, Portable Power Bank USB Hand Warmers 4 Levels 8 Heating, Gifts for Raynauds Ski Golf Camping

(683)
$74.08$59.47
FREE delivery Jun 13 - 18
Loading...
Hand Warmers Rechargeable, 10000mAh Electric Heated Gloves Power Bank Portable Graphene Handwarmers Pouch with 3 Levels & Double-Sided Heating for Hunting Camping Golf Xmas Gifts for Women Men Kids

Hand Warmers Rechargeable, 10000mAh Electric Heated Gloves Power Bank Portable Graphene Handwarmers Pouch with 3 Levels & Double-Sided Heating for Hunting Camping Golf Xmas Gifts for Women Men Kids

(651)
$44.99
PrimeFREE delivery Sun, Jun 15
Loading...
2Pack Rechargeable Hand Warmer, 8000mAh Electric Hand Warmer Power Bank, Portable USB-C Hand Warmer for Pocket, Reusable Hand Warmer Up to 8 hrs Each, Warm Gift for Men Women, for Hunting, Camping
Amazon's Choice

2Pack Rechargeable Hand Warmer, 8000mAh Electric Hand Warmer Power Bank, Portable USB-C Hand Warmer for Pocket, Reusable Hand Warmer Up to 8 hrs Each, Warm Gift for Men Women, for Hunting, Camping

(1,128)
$15.99
FREE delivery Sat, Jun 14 on your first order
Loading...
GTOCE Portable Charger,40000mAh Power Bank with 22.5W Fast Charging LED Digital Display Battery Pack with 6 Outputs 2 Inputs, Type C Powerbank Portable Charger for iPhone 16 pro Samsung AirPods,Black

GTOCE Portable Charger,40000mAh Power Bank with 22.5W Fast Charging LED Digital Display Battery Pack with 6 Outputs 2 Inputs, Type C Powerbank Portable Charger for iPhone 16 pro Samsung AirPods,Black

(334)
$42.99
FREE delivery Thu, Oct 16
1K+ bought in past month