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
How to make one slıcer of dıvıded and unıque names in the following file?
http://8upload.ir/uploads/f3691782.zip
Noah, Thomas, Lucas |
William, Lucas, Mateo |
James, Gabriel, Logan |
Logan, Lincoln, Isaac |
Benjamin, Daniel, Michael |
Mason, Charles, Matthew |
Elijah, Michael, Thomas |
Oliver, William, Charles |
Jacob, Dylan, Joshua |
Lucas, Elijah, Wyatt |
Michael, Mateo, Levi |
Alexander, Aiden, John |
Ethan, Julian, Carter |
Daniel, Caleb, David |
Matthew, Isaac, Lucas |
Aiden, Levi, Isaiah |
Henry, Ryan, Isaiah |
something like this?
Is there no other way than Power Query?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