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

Hi Leila,
Please explain the same function how to use in Desktop 365 Excel software
Regards

She is one of the best Excel teachers on the Internet.

thank you for this video. figured out a function ive been trying to get done on a sheet for the last 3 days

Hi. I need to filter a pivot table based on unique values of a particular columns data in google sheets. Can you help?

If I could use a Voice note, you'd have heard me crying tears of joy... As an entry level Data Analyst, this had been an issue for me for hours and I couldn't find a good solution... Thanks and I'm subscribed 😊

Great tip!

I don't know if arrayformulas didn't exist at this time, but you can recreate this for combinations of columns using =UNIQUE({range1;range2;range3}) which appends the ranges and then uniques them. I assume you could use arrays{} in this case as well in place of flatten?

You're a life saver madam! Thank you so much for this, it is EXACTLY what I was struggling with. ♥

Osum Video Mam, Very Useful to me and all.
Thanks
Please make a detailed video on Which is better between M.S. Office and Google Sheets.
Thanks 😊

SWEET!

How do I make unique groups that haven't before been together in a group using filter and unique? Students down the left in column A, and groups assigned in each column (1-5). I rotate teams 5 times in a semester and want students to be with different people every group assignment. Can anyone point to the combinations of functions I should use?

Is it possible to use multiple unique functions in 1 cells? Could you make a tutorial for it?

Waiting for ❤❤ really helpful for real time jobs

Is this works in multiple rows ina addition to multiple sheets?

Could you make a tutorial of this?

unique list from multiple rows and sheets..❤

Holy, you saved my day!

For Excel:
TOCOL

♡

I'm using office 365, primarily excel, creating dynamic queries with msqry. Looking into Power query due to enhanced complexity

Your knowledge is amazing. This video solved a vexing problem I had that no one came close to providing the right formulas.

How can I do it in Excel or Excel365?

Exactly what I wanted. Aaaaahhhh

Thank you Leila, that was really helpful!

Yes! Thank you, I needed something like this. I was using Unique 2 times for something similar (first to just wrap all the names in one different sheet, then choosing each individual column to return the names in a single column in that same sheet). This will be faster and better.

Hi Leila,

I have been stuck with this issue for 3 hours but your video has helped me to solve it quickly. Thanks!

how did you get " ?" in front of your formula

Flatten is not recognized in my Excel. Anyone knows why or how to resolve it? This is quite annoying as every other function to do this uses vstack/tocol which is also a new function and not yet available across the globe.... it seems near impossible to merge multiple columns into one if you don't have the latest updates since mid 2022..... I'm spending hours on this already :((

Amazing tip n well explained. thank you very much. 🙂

How do we do this on Excel? Your feedback is appreciated

for the distinct america you could simplify by simply using unique as an array =UNIQUE({col1;col2;col3:col5}) then use sort. cleaner and faster

YEAH!!!!! Thank You!

FLATTEN does the job!!

Once again - Thank you Leila. I have tried for 2 days to figure how to achieve in excel what =UNIQUE(FLATTEN(XX:XXXX)) does in sheets. I have your Udemy PQ course and a couple of your others, searched high, low and in between. Watched hours of you tube vids, and the feeling when all of that gets solved in 2mins40 of your mellifluous voice simply cannot be described. Thanks just is not enough.👍👍😍😍

First of all, Thank you so much.
I have a question here:
Once this Unique list is ready, can we use same values/column and apply VLOOKUP value here?

For example: In this video, I use VLOOKUP value from column G.

Thanks in advance.

hello,
first, thank you for your helpful video.
my question about FLATTEN Function is not available any more, could you please give any solution to have my data in one column.

awesome way of teaching

Just what I was looking for, thank you.

MADAM SUPPOSE i want to filter such data which is common in all column for example Baden is common in all columns what will it's formula. Or can you send video link if it's uploaded in channel???

Thank you So much Big Problem simple solutions

gracias por tu sabiduría

Thank you Ms. Leila for this video tutorial. It is the small things that add up in the end to make a workable solution. And you help me every day.

I wish you could have heard me scream when you whipped out the FLATTEN function that fixed the exact problem I was having. Thanks for the awesome tutorial!

how do we do this in excel?? :(

Thank You Very Much !

Thanks a lot, I spent 2 hours in doing what you have done in less than a minute, :)

Amazing!!! Thank you for this. You're the best!

Thank you for these amazing tutorials.
I have been struggling with this for a while, please help.

I need to compare two Columns in a data sheet and get only those which are not repeated.

For example

Column A: 1, 2, 3, 4, 5
Column B : 2, 5

I need in Column c : 1, 3, 4

Thank you. This video is a life saver!

Is FLATTEN formula available in Office 365? I couldn't find it in my Office 365.

AWESOME! I was having a really hard time transforming an array into a single column and filtering

Why i should buy your Udemy course on google sheets / excel if you have already manies videos about it ?

Hi laila can you make a video about how to import an image from other google sheet file? Thank you for your help