Ungrouping just part of a group in a pivot table

[benjtp]

Hi,

I have grouped hundreds of items into different groups based on different parameters. For example all products that have to do with paper, all ones that have to do with pens etc.
I therefore have product group and product group 2.
However, I need to remove one of them to essentially make it a separate group.
The only way I have managed to do so is to start over by ungrouping everything. Redoing it will take me hours. There must be a better solution than that.
Thanks in advance.

 

[RoryA]

Yes, you can select all the other items in the group and regroup them. That will create them as one group and your single item as its own group.

 

[benjtp]

You just need a two column table somewhere with the product group in the first column and the parent group in the second column. Then it's a simple =vlookup(product group, product group table range, 2, false) or, if you can sort the lookup table and be sure that all the groups are in there, you can use the faster form =vlookup(product group, product group table range, 2)

Hi, I'm still not fully understanding this. I have let's say 100 different named products and want to group them into one single group. The same for another 50 etc. How do I go about making this vlookup.
Thanks so much