Hello,
I don't even know what key words to use to search for the answer to this question, so I'm asking for assistance with the problem, and possibly advice on key words I could use to search for answers to similar problem in the future.
I would like this:
| DINNER | ITEM |
| THANKSGIVING | TURKEY |
| THANKSGIVING | POTATOES |
| THANKSGIVING | GRAVY |
| THANKSGIVING | SODA |
| XMAS | TURKEY |
| XMAS | POTATOES |
| XMAS | GRAVY |
| XMAS | STUFFING |
| EASTER | HAM |
| EASTER | POTATOES |
| JULY4 | HOTDOG |
| JULY4 | SODA |
| BDAY | HAM |
| BDAY | SODA |
to look like this:
| DINNER | ITEM |
| THANKSGIVING | TURKEY |
| | POTATOES |
| | GRAVY |
| | SODA |
| XMAS | TURKEY |
| | POTATOES |
| | GRAVY |
| | STUFFING |
| EASTER | HAM |
| | POTATOES |
| JULY4 | HOTDOG |
| | SODA |
| BDAY | HAM |
| | SODA |
or even this:
| DINNER | ITEM |
| THANKSGIVING | TURKEY |
| POTATOES |
| GRAVY |
| SODA |
| XMAS | TURKEY |
| POTATOES |
| GRAVY |
| STUFFING |
| EASTER | HAM |
| POTATOES |
| JULY4 | HOTDOG |
| SODA |
| BDAY | HAM |
| SODA |
The goal is to replace duplicates in the DINNER column with empty cells, or to merge a DINNER items into a single cell, while keeping the corresponding ITEM items attached.
Thanks,
Nick
