Hi,
I have a list of data that I want to turn into a table so I can use it for dynamic drop down boxes
I have manually created both but I would love for the list to automatically update the table so when I want to add a new item I don't have to add it in two worksheets
Basically I have a List as such (my actual list is 900 items long):
And I would like it to automatically update to a Table such as:
I tried pasting it using transpose but this doesn't group the food category and have attempted nesting loops but I keep getting stuck.
I would appreciate any help or ideas.
Thank you
I have a list of data that I want to turn into a table so I can use it for dynamic drop down boxes
I have manually created both but I would love for the list to automatically update the table so when I want to add a new item I don't have to add it in two worksheets
Basically I have a List as such (my actual list is 900 items long):
Food Category | Type |
Fruit | Apple |
Fruit | Banana |
Vegetable | Carrot |
Vegetable | Celery |
Vegetable | Cauliflower |
Nuts | Peanuts |
And I would like it to automatically update to a Table such as:
Fruit | Vegetable | Nuts |
Apple | Carrot | Peanuts |
Banana | Celery | |
Cauliflower |
I tried pasting it using transpose but this doesn't group the food category and have attempted nesting loops but I keep getting stuck.
I would appreciate any help or ideas.
Thank you