how to divide and unique names in to one slicer

[aboly8000]

Hello
How to make one slıcer of dıvıded and unıque names in the following file?

http://8upload.ir/uploads/f3691782.zip

 

[aboly8000]

any help?

 

[gaz_chops]

I doubt many will want to open a zip file!
Better if you post a sample and an explanation of what you are trying to achieve.

 

[aboly8000]

i have many name in one column and i want make one unique and divided slicer for

[TABLE="width: 174"]
<colgroup><col></colgroup><tbody>[TR]
[TD="align: left"]Noah, Thomas, Lucas[/TD]
[/TR]
[TR]
[TD="align: left"]William, Lucas, Mateo[/TD]
[/TR]
[TR]
[TD="align: left"]James, Gabriel, Logan[/TD]
[/TR]
[TR]
[TD="align: left"]Logan, Lincoln, Isaac[/TD]
[/TR]
[TR]
[TD="align: left"]Benjamin, Daniel, Michael[/TD]
[/TR]
[TR]
[TD="align: left"]Mason, Charles, Matthew[/TD]
[/TR]
[TR]
[TD="align: left"]Elijah, Michael, Thomas[/TD]
[/TR]
[TR]
[TD="align: left"]Oliver, William, Charles[/TD]
[/TR]
[TR]
[TD="align: left"]Jacob, Dylan, Joshua[/TD]
[/TR]
[TR]
[TD="align: left"]Lucas, Elijah, Wyatt[/TD]
[/TR]
[TR]
[TD="align: left"]Michael, Mateo, Levi[/TD]
[/TR]
[TR]
[TD="align: left"]Alexander, Aiden, John[/TD]
[/TR]
[TR]
[TD="align: left"]Ethan, Julian, Carter[/TD]
[/TR]
[TR]
[TD="align: left"]Daniel, Caleb, David[/TD]
[/TR]
[TR]
[TD="align: left"]Matthew, Isaac, Lucas[/TD]
[/TR]
[TR]
[TD="align: left"]Aiden, Levi, Isaiah[/TD]
[/TR]
[TR]
[TD="align: left"]Henry, Ryan, Isaiah[/TD]
[/TR]
</tbody>[/TABLE]

 

[aboly8000]

https://docs.google.com/spreadsheets/d/1AsGsuwlZUBaARSp5gbk8x3PZd0RNRTrFTqFbbaWquCI/edit?usp=sharing

 

[sandy666]

something like this?

 

[aboly8000]

something like this?

yes

 

[sandy666]

use PowerQuery
split first column by delimiter ", " (comma space) to rows

then you can:
create PivotTable from Query Table and insert slicer
or
load Query Table to the sheet and insert slicer

---
Slicer Size and Properties - Number of columns = 3

btw. don't quote whole post, it doesn't make sense

 

[aboly8000]

use PowerQuery
split first column by delimiter ", " (comma space) to rows

then you can:
create PivotTable from Query Table and insert slicer
or
load Query Table to the sheet and insert slicer

---
Slicer Size and Properties - Number of columns = 3

btw. don't quote whole post, it doesn't make sense

Is there no other way than Power Query?

 

[sandy666]

I don't know
Get it or forget it