roylionking
New Member
- Joined
- May 21, 2014
- Messages
- 6
Hi, been struggling with this, even into the rabbithole of pivot table 'measures'...
I've got a bunch of names in a column.
Against each, in the next column I've got a category I've given them.
The columns are fixed but I might add new names and change the assigned categories.
All? I want to be able to do is have a table with columns with the categories, and under each one a list of names assigned to it..
Like..
becoming
Seems simple but I can't figure it out... Help please!
I've got a bunch of names in a column.
Against each, in the next column I've got a category I've given them.
The columns are fixed but I might add new names and change the assigned categories.
All? I want to be able to do is have a table with columns with the categories, and under each one a list of names assigned to it..
Like..
Apple | Green |
Orange | Orange |
Pear | Green |
Apricot | Orange |
Grape | Green |
becoming
Green | Orange | Red... |
Apple | Orange | etc |
Pear | Apricot | |
Grape |
Seems simple but I can't figure it out... Help please!