Separate One Cell Data into Multiple Rows

[nputt]

Am I able to filter my formulas at the bottom of my table back into a single column, multiple rows (the values are separated by commas); I've tried the delimiters using google search but it doesn't appear to be working how I need it to.
Ideally, I would like the formulas for: Meat, Dairy, Fresh Produce, Frozens, Package&Canned(Dry), and Condiments&Spices; to be sorted into columns for each category while maintaining dismissal of duplicates.
The main problem I'm running into is that the formula needs to be repasted as values only, in a separate cell, in order to then separate again into one column, multiple rows using the delimiters formulas.
I could easily, copy, paste, and remove duplicates from the table manually, but each time I add a new recipe I would have to repeat the process.
The point is so that I have tables for each category, that contains no duplicates, and would automatically readjust each time I add a new recipe without any manual input.
Is this possible?

I apologize if this was repetitive in my explanation.

Thank you for any assistance!!!

Book1
	A	B	C	D	E	F	G	H	I	J
1	Meals
2	Shredded Meats: Using the INSTANTPOT, add Meat, spices, and 2 cups of Stock/Sauce (1 cup if using just water to cook chicken) Coating meat in cornstarch tenderizes the meat and allows it to absorb flavors better | Vodka assists oils and water to mix ands adds a gentle bite Remoulade Dip: 1 1/4 cups mayo, 1/4 cup mustard, 1 tbspn sweet paprika, 1-2 tspns Cajun seasoning, 2 tspns horseradish, 1 tspn pickle juice, 1 tspn hotsauce, 1 garlic clove
3	Course	Focus	Fresh Meat	Dairy	Fresh Produce	Frozens	Packaged & Canned (Dry)	Condiments & Spices	Need a Side?	Prep
4	Bean Lasagna	Meatless		Mozzarella Shredded			Beans, Beans Refried, Noodles Lasagna	Garlic Powder, Onion Powder	NO	Boil Lasagna Noodles (or follow directions on box if oven-ready) mix Beans, Refried Beans, Powder Garlic, Salt, Powder Onion in bowl. Layer in dish: Bean Mix, Cheese, Noodles, repeat until full.. Bake @ 375* for 30-45 minutes.
5	Beef Stew	Beef	Stew Beef		Carrots, Celery, Mushrooms, Onion Green, Potatoes		Broth Beef	Beef Gravy (Powdered), Garlic Powder, Parsley	NO	Add Stew Beef, fresh Baby Carrotss, canned/cut Potatoes, msuhrooms, Green Onion, & Beef Stock Broth to CROCKPOT, ensure all Meat & Veggies are covered by Broth. Season with Garlic Powder. Heat on high for 6 hours. Low for 8 hrs. Sprinkle chopped parsley when serving.
6	Beef Tips & Gravy	Beef	Stew Beef			Mixed Veggies	Mashed Potatoes	Beef Gravy (Powdered)	NO	CROCKPOT: Stew Beef, Gravy on low for 4 hours, (high for 6). Add Peas and Corn and continue cooking for an additional hour. Top over mashed Potatoes.
7	Brown Sugar & Garlic Pork	Pork	Porkloin					Brown Sugar, Garlic Powder, garlic, Onion Powder	YES	Bake @ 375* for 40 minutes.
8	Buffalo Chicken Pasta Bake	Poultry	Chicken Breasts	Mozzarella Shredded, bleu cheese	Onion Purple		Noodles Spirals/Shells	Sauce Buffalo	NO	INSTANTPOT Chicken w/buffalo sauce and half cup of water; Boil Noodles separately. Shred Chicken in oven dish, add Noodles & Mozzarella Shredded, stir mixture, top with more Mozzarella Shredded & Bread Crumbs. Bake for 20 minutes @ 350*.
9	Bulgogi Pork Bowls	Pork	Ground Pork	Sour Cream	Carrots, Cucumber, Onion Green		Rice, Sesame Seeds White	Sauce Bulgogi, Sauce Gochujang	NO	Cook the pork in sesame oiled pan, add bulgogi sauce and continue cooking until glazed. Mix together sour cream and gochujang to form sauce. Cut the cucumbers and Carrotss into matchsticks, and cut the green Onion fully. Top pork, Carrotss, and cucumbers over Rice, sprinkle Sesame Seeds White, chopped green Onion, and drizzle sauce on top.
10	Burgers	Multi-Meat			Lettuce, Tomato	Burgers Frozen	Buns Burger, Pickles	Sauce Mayo, Sauce Mustard, Sauce Ketchup	Fries	Pan cook as instructed and top with preferred toppings.
11	Burritos (tacos)	Beef	Ground Beef	ColbyJack Shredded, Sour Cream	Lettuce, Tomato, Avocado		Beans Refried, Salsa, Tortillas/Taco shells	Taco Seasoning Mix	NO	Brown Ground Beef in pan, add Taco Seasoning. Top with options.
12	Cajun Garlic Cod	Seafood				Cod		butter, olive oil, garlic, cajun seasoning	YES	Preheat oven to 400*. Whisk together butter, garlic, oil, and cajun seasoning, then spread over fish fillets and bake for 15 minutes until flaking.
13	Cheesburger Soup	Beef	Ground Beef	ColbyJack Shredded, Milk	Carrots, Onion Purple, Potatoes			Garlic Powder, Onion Powder	NO	Brown ground beef with Powder Garlic, Pepper, and Salt and chopped veggies. Stir in cheese, milk, soup, and noodles until combined, left simmer until noodles tender.
14	Cheesy Chicken Chowder	Poultry	Chicken Breasts	Milk, Cheddar Shredded	Carrots, Celery, Onion Purple, Potatoes		Broth Chicken	Flour, Butter	NO	Boil broth and add potatoes, Carrotss, celery, and onion. Cut chicken into bite-sized chunks and cook thoroughly. In separate pan, melt 1/4 cup butter and stir in 1/3 cup flour. Gradually stir in 2 cups milk and bring to boil stirring occasionally until thickened. Reduce heat and add cheese stiring until melted, then add the broth, vegetables, and cooked chicken.
15	Cheesy Tomato & Beef	Beef	Ground Beef	ColbyJack Shredded	Tomatoes		Rice	onion powder, garlic powder, Parsley	NO	Brown Ground Beef, add Tomato Sauce & Mixs (Garlic, Onion, Celery Salt, paprika). Prepare Rice. Stir Ground Beef together in oven dish, cover wih Cheese & bake @ 350* for 20 minutes.
16	Chicken & Dumplings	Poultry	Chicken Breasts			Mixed Veggies	Broth Chicken, Pillsbury Biscuits	garlic, Parsley	NO	Ball Pillsbury biscuits and toss all ingredients into CROCKPOT; heat on low for 8 hours or high for 4-6.
17	Chicken & Garlic Noodles	Poultry	Chicken Breasts	Mozzarella Shredded			Noodles Spirals/Shells	Butter, Garlic Powder, Onion Powder, Italian Blend Seasoning	NO	Panfry chopped chicken with Garlic Powder and Onion Powder. Once noodles are boiled and softened, stir together noodles with Butter, Garlic Powder, Italian Blend Seasoning and Mozzarella. Top the noodles with chicken.
18	Chicken & Rice Bake	Poultry	Chicken Breasts	Milk			Rice, broth chicken	Onion Soup Mix, garlic, Parsley	NO	Cut and cook chicken breast. Put all ingredients in oven safe dish. Bake @ 375* for 35 minutes.
19	Chicken & Veggie Pasta	Poultry	Chicken Breasts	Mozzarella Shredded	Bell Pepper Red, Carrots, Onion Purple, Tomatoes		Noodles Spirals/Shells	Garlic Powder, Onion Powder	NO	INSTANTPOT the chicken. while thats going boil pasta, cut veggies, and make sauce.
20	Chicken Broccoli & Rice	Poultry	Chicken Breasts	ColbyJack Shredded, Milk	Broccoli		Rice, broth chicken		NO	Prepare Rice & add to dish. INSTANTPOT Chicken. Shred apart and add to dish. Cut heads off Broccoli & add to dish. Add Cream Soup & stir Together, add layer of Cheese on top. Bake in oven @ 350* for 20 minutes
21	Chicken Fried Rice	Beef	Meat, Eggs			Mixed Veggies	Rice	Sauce Soy, Sesame Oil, Fried Rice Seasoning	NO	Cook Rice in Rice cooker. Cook meat in pan with sesame seed oil and soy sauce. Fry a couple of eggs until well scrambled. stir fry together eggs, veggies, and beef, then add Rice and mix in Fried Rice Seasoning. Mix well and serve.
22	Chicken Pot Pie	Poultry	Chicken Breasts	Milk		Mixed Veggies	Pillsbury Biscuits, Broth Chicken	Garlic Onion,	NO	INSTANTPOT Chicken. Layer Biscuits on the surface of dish & bake as directed. In a pot on the stove prepare Cream of Chicken. Add in the Chicken, & Frozen Veggies, Salt to taste. Once heated pour into biscuit dish. Add a layer of Biscuits on top of dish & bake for a shorter period of time than directed on biscuits, as all items are cooked except the Biscuits on top
23	Chicken Rice Soup	Poultry	Chicken Breasts		Carrots, Mushrooms		Broth Chicken, Rice	Garlic Powder, Onion Powder, Parsley	NO	CROCKPOT Chicken Breasts, Chicken Stock, Carrotss, Celery, Powder Onion, Parsley, Salt for 6 hours on high, 8 on low. Add Mushrooms and Milk, and prepare Rice. Once soup is well combined, pour over white Rice.
24	Chicken Wraps	Poultry	Chicken Breasts	ColbyJack Shredded	Lettuce, Tomato		Tortillas	Sauce BBQ, Sauce Buffalo, Dressing Ranch	NO	INSTANTPOT Chicken, shred with forks. Add preferred toppings.
25	Chili	Beef	Ground Beef		Lettuce, Tomato		Beans, Green Chilis, Rice	cayenne pepper, Garlic Powder, Onion Powder	NO	Brown Ground Beef in Soup pot, add Beans, Green Chilis, & Tomato Sauce to pot. Season with Cayenne, Salt, Garlic, & Onion.
26	Corn & Bean Bowls	Meatless		ColbyJack Shredded	Onion Purple, Tomato		Beans, Broth Beef, Chips Tortilla, Corn, Rice	Taco Seasoning Mix, Juice Lime	NO	Add broth, corn, beans, and chopped Onion, and tomato to pot and simmer, season with taco seasoning mix. In separate container mix together Juice Lime and sour cream, add water until drizzle consistency. Top the mix over Rice and sprinkle with Cheese and drizzle with sauce. And use tortilla chips to scoop or add crushed to bowl.
27	Cream of Turkey & Wild Rice Soup	Poultry	Turkey Breast	Milk	Mushrooms, Onion Purple		Broth Veggie, Rice Wild	Butter, Parsley	NO	Fully cook turkey meat and set aside. Saute Mushrooms and Onion in butter until tender. Add 3 cups water, 2 cups broth and Long Grain Wild Rice and bring to a boil. Reduce and simmer for 25 minutes until rice is tender. Stir in cooked turkey and cream, heating thoroughly. Top with parsley.
28	Creamy Chicken Chili	Poultry	Chicken Breasts	Cream Cheese, Colbyjack Shredded	Jalapenos, Onion Green, Onion White		Chips Frito, Beans, Broth Chicken, Green Chilis	Taco Seasoning Mix	NO	Combine all ingredients except Frito Chips & Green Onion. Mix and let simmer. Top with Frito Chips & Green Onion.
29	Creamy Chicken Marsala	Poultry	Chicken Breast	whipping cream	mushrooms		marsala wine	butter	YES	flatten chicken to 1/2 in thick, season both sides with salt and pepper. melt butter in pan and add chicken once melted. cook until golden on each side, move to plate. add butter and mushrooms until shrooms tender, then add marsala wine and simmer. Add cream and combine well. Replace chicken in pan and simmer until sauce has thickened.
30	Creamy Lemon Sauce Chicken	Poultry	Chicken Breasts	Crème Fraiche, Milk	Onion Green		Hazelnuts	Butter, Garlic, Crushed Red Pepper, HERBS?, Juice Lemon, Parsley	NO	Preheat oven to 400*. Cut shallots into slices. Toast hazelnuts until fragrant. Chopped cooled toasted hazelnuts. Sear the chicken breast (3 minutes each side) and then set aside. Saute the shallots until translucent. Mix together lemon crema (Creme Fraiche, lemon, Garlic, parsley.) Add 1/4 cup of water to the sauce and place chicken back in pan. Cook in the oven for 10 minutes. Season with HERBS?, Garlic and red pepper. Add hazelnuts and stir all together until everything is fork tender. Plate the chicken and spoon the remaining sauce over the chicken.
31	Cumin Spiced Shrimp	Seafood		Cotija, Crème Fraiche	Avocado, Bell Pepper Orange, Cabbage, Onion Purple, Tomato Grape	Shrimp	Pepitas	Cumin, parsley, Garlic, Basil, vinegar red wine, olive oil, Juice Lemon	NO	Preheat oven to 400*. Make the chimichurri sauce (parsley, Garlic, Basil, red wine vinegar, olive oil, Juice Lemon, avocado, crème fraiche). Chop cabbage, peppers, and Onion, halve the grape tomatoes. Saute cabbage, pepper, and Onion, season with salt and pepper. Transfer to foiled pan and bake for 8 minutes, stirring around halfway through. Rinse the shrimp and add to hot pan, season with salt pepper and cumin. Stir to evenly coat, cook until opaque. Heat pan with oil and toast pepitas for about 3 minutes. Put veggies in bowls, add tomatoes, cotjia, and pepitas. Top with shrimp and drizzle with chimichurri sauce.
32	Dill Parm Salmon	Seafood		Parmesan Shredded		Salmon		Sauce Lemon Butter Dill	YES	Coat Salmon in Lemon Butter Dill Sauce, top with Cheese and bake @ 425* for 30 minutes or as directed
33	Dill Seafood Pasta	Seafood			Onion Purple	Salmon, Shrimp	Noodles Spirals/Shells	Sauce Lemon Butter Dill, Butter	YES	Prepare fish and shrimp as directed, add Butter and Onion Minced to cooking method. Boil Noodles. Combine shredded seafood with noodles and mix well with dill veggie dip.
34	Fajita Bowls	Poultry	Ground Turkey	ColbyJack Shredded, Sour Cream	Bell Pepper Orange, Onion Purple, Tomato		Broth Veggie, Rice	Taco Seasoning Mix	NO	Cut the veggies and start the Rice. Create the drizzle by combining sour cream, taco seasoning, and just enough water for it to drizzle. Cook the peppers and Onion until tender. Cook the ground turkey until browned, add Broth and taco seasoning and the veggies (including tomatoes) and cook until everything in tender and combined well. Top over cooked Rice, sprinkle with Cheese, and drizzle prepared sauce.
35	Fajitas	Poultry	Chicken Breast	ColbyJack Shredded, Sour Cream	Lettuce, Tomato, Avocado		Beans Refried, Salsa, Tortillas	Taco Seasoning Mix	NO	Cook the fajita meat in pan with Taco Seasoning until heated and well seasoned.
36	Filipino Adobo Chicken	Poultry	Chicken Breast, Bacon		Onion White, Lime		honey, rice	garlic, 1/4 cup dry sherry, sauce soy, ginger, sauce chili garlic, sesame seeds	NO	In a large skillet, cook bacon over medium heat until crisp, stirring occasionally. Remove and drain. Brown chicken in ttbspn bacon drippings (discarding rest) in batches. Transfer chicken to slow cooker. Add onion to pan; cook and stir until tender. Add garlic; cook and stir 1 minute longer. Finely grate lime zest for 2 teaspoons. Cut limes crosswise in half; squeeze juice from limes. Add the lime juice and zest, sherry, soy sauce, honey, ginger, pepper and chili sauce to pan; cook and stir then pour over chicken. Cook, covered, on low 6-8 hours. Shred meat. Stir in bacon. Serve with rice topped with sesame seeds.
37	Fish & Mushroom	Seafood			Mushrooms, Onion Green	Tilapia		Brown Sugar, garlic, Sauce Soy, Cayenne Pepper, Sauce Oyster	YES	Mix together garlic, Brown Sugar, Cayenne Pepper, Oyster Sauce, and Soy sauce in pan with mushrooms until mushrooms are browned, add Tilapia to pan with chopped green Onion until flesh flakes and is opalescent
38	Garlic Crab & Broccoli	Seafood			Broccoli	Crab		garlic, Juice Lemon, Butter	NO	Pan fry Butter, Juice Lemon, garlic, and broccoli until broccoli is tender. Stir in Crab pieces (imitation or true) until well mixed.
39	Garlic Mushroom Chicken	Poultry	Chicken Breasts		Mushrooms			Butter, Garlic Powder, garlic, Onion Powder	YES	Add Butter & Mushrooms to pan. Once Mushrooms are browned, add garlic and Chicken Breasts until fully cooked.
40	Garlic Mushroom Pork	Pork	Porkchops		Mushrooms, Potatoes			Butter, Garlic Powder, garlic, Onion Powder	YES	Add Butter & Mushrooms to pan. Once Mushrooms are browned, add garlic and Pork Chops until fully cooked.
41	Golden Squash Soup	Meatless		Cheddar Shredded, Sour Cream	Squash Butternut, Leeks, Onion Green		Broth Veggie	Thyme, Tumeric, butter	NO	Saute leeks in butter until tender, stir in squash, broth, thyme, tumeric and bring to a boil. Reduce heat and simmer for
42	Goulash	Beef	Ground Beef			Mixed Veggies	Rice, tomato soup	Sauce Soy	NO	Brown Ground Beef. Add Carrotss, Corns, Peas, & Tomato Sauce. Add Soy to flavor. Serve over prepared Rice.
43	HamBurger Hash	Beef	Ground Beef	ColbyJack Shredded		Hashbrowns	Soup Cream Mushroom		NO	Brown Ground Beef in pan. Add to dish with can of Cream of Mushroom Soup, Cheese, & Frozen Frozen Hashbrowns, stir. Bake @ 425* for 30 minutes. Add top layer of Cheese & bake for another 10 minutes.
44	Honey Garlic Chicken	Poultry	Chicken Breasts				honey	garlic, Sauce Soy	YES	soak Chicken in Soy Sauce, Honey, & Garlic at least 30 minutes. Cook Chicken in pan, when finished drizzle (pan) Sauce over Chicken.
45	Honey Garlic Pork	Pork	Porkchops				honey	garlic, Sauce Soy	YES	soak Pork in Soy Sauce, Honey, & Garlic at least 30 minutes. Cook Pork in pan, when finished drizzle (pan) Sauce over Pork.
46	Honey Garlic Salmon	Seafood			onion green	Salmon	Sesame Seeds white, honey	sauce soy, garlic, vinegar white	YES	Pat Salmon dry then whisk together (soy, honey, garlic, vinegar). Cook salmon for about 1-2 minutes until fish thickening, Pour sauce of salmon and continue cooking until fish is flaky. Serve with sesame seeds and chopped green onion.
47	Honey Garlic Shrimp w/Broccoli	Seafood			onion white	Shrimp, broccoli	honey, rice	garlic, sauce soy, cornstarch, sesame oil, gochujang	NO	Make rice as usual. Steam broccoli. Whisk together cornstarch and soy until smooth. Add sesame oil, gochujang, and honey until combined. Add shrimp to preheated pan, laying in single layer to not overcrowd. Cook for 1 minute then flip each one and cook another minute until opaque. Set shrimp aside. Cook onion until tender, add garlic until fragrant then add the broccoli cook until fully tender. Add the sauce to skillet and cook with veggies until thickening, then add the shrimp and toss together until warm and incorporated. Serve topped with sesame seeds over rice.
48	Jambalaya	Poultry	Chicken Breasts, Polska Sausage		Celery, Onion Purple		Broth Veggie, Rice, Tomatoes Diced Fire Roasted	Garlic Powder, Cajun Seasoning, Tumeric	NO	Add to CROCKPOT: Sausage, Chicken Breasts, Onion, Celery, Garlic Powder, Cajun Seasoning, Broth, Fire Roasted Diced Tomatoes. Cook for 6-8 hours on low, 4-6 on high. Top over cooked Rice.
49	Japanese Curry	Poultry	Chicken Breasts		Carrots, Potatoes, Leeks, Onion Green, Apple Red		S&B Curry Powder 3 tbsp, Broth Chicken 3cups, Tomato Paste 1tbsp, honey	Garlic powder, Sauce Chunou 2tbsp, cocoa powder1tspn, butter, flour, brown sugar	NO	Cut chicken into chunks and saute with salt and pepper. Let simmer and brown on each side. Set Chicken aside and sautee green onions with garlic until carmelizing. Add the curry powder and stir together, then add the chicken back, with broth, cocoa powder, brown sugar, chopped carrots and potatoes, tomato paste, grated apple, and chunou sauce. Boil together until everything tender. Make roux while boiling: butter and flour on medium heat until browning. Add honey to pot (taste it to ensure the flavor is right!), then stir in the roux slowly, let simmer until thickened.
50	Korean BBQ Beef	Beef	Stir Fry Beef		Mushrooms, Onion Green		Baby Corn, Water Chestnuts	Sauce Korean BBQ, Sauce GoChuJang	YES	Cut stir fry beef into bit sized portions. Mix together Korean BBQ sauce and GoChuJang and soak meat for 30 minutes. Pan fry meat with veggies.
51	Korean BBQ Porkchops	Pork	Porkchops				Rice	Sauce Korean BBQ, Sesame Oil, Sauce Gochujang	NO	Mix together Korean BBQ Sauce, GoChuJang, (and Sherry if you have some). Add Sesame Oil to pan and fry pork with sauce. Top over Rice.
52	Lasagna Soup	Beef	Ground Beef	Mozzarella Shredded	Tomato		Broth Beef, Noodles Lasagna	Dressing Italian Mix, Garlic Powder, Onion Powder, Parsley	NO	Add all items to CROCKPOT (except Cheese) and cook on low 8 hours, high 6.
53	Lemon Mushroom Chicken	Poultry	Chicken Breasts		mushrooms		Broth Chicken	Flour, butter, lemon juice, salt	YES	Flatten chicken to 1/2-in. thickness. In a large shallow dish, combine 1/4 cup flour, salt and pepper. Add chicken, 1 piece at a time; turn to coat. In a large nonstick skillet over medium heat, cook chicken in butter for 5-6 minutes on each side or until no longer pink. Remove and keep warm. Add 1/3 cup broth to the pan, stirring to loosen browned bits. Bring to a boil. Add mushrooms; cook and stir for 3-5 minutes or until tender. Combine the remaining flour and broth until smooth; stir into the mushroom mixture. Bring to a boil; cook and stir until thickened, about 2 minutes Stir in lemon juice. Serve with chicken.
54	Lemon Pepper Pork	Pork	Ground Pork		Carrots, Squash Yellow		Almonds, Honey	Lemon Pepper, Parsley, Onion Powder, Garlic Powder, Butter, Crushed Red Pepper, Vinegar White Wine, Olive Oil	NO	Mix together Ground Pork, Lemon Pepper, Onion Powder, Garlic Powder. Form patties. Add butter to pan and cook Carrotss and squash until tender. Add in Almonds and Honey, gently season with Crushed Red Pepper, stirring until evenly coated. Removed from heat, and cook patties (about 5 minutes each side). Serve overtop veggies. Drizzle with White Wine Viniagrette (White Wine, Olive Oil, Garlic Powder, salt)
55	Maple Mustard Salmon	Seafood				Salmon	maple syrup	olive oil, dijon mustard	YES	Preheat oven to 425* whisk together syrump, mustard, oil; then pour over salmon and bake until flaking about 15 minutes depending on thickness
56	Meatloaf Philly Cheese Steak	Beef	Ground Beef	Swiss Sliced	Bell Pepper Green, Onion Purple		Breadcrumbs	Onion Soup Mix	NO	Mix Ground Beef, Bread Crumbs, Bell Pepper Green, Onion, and Onion Soup Mix. Roll together in log shape. Bake @425* for 20 minutes. Lay sliced Cheese over top and bake additional 5-10 minutes or until Cheese is fully melted/bubbly.
57	Minestrone	Beef	Stew Beef	Parmesan Shredded	Onion Green	Mixed Veggies	Broth Beef, Noodles Spirals/Shells, Tomatoes Diced	Dressing Italian Mix, Garlic Powder, Onion Powder	NO	Add all items to CROCKPOT (except Cheese) and cook on low 8 hours, high 6. Serve topped with Parmesan.
58	Mongolian Beef	Beef	Stir Fry Beef		Carrots, Onion Green		honey	garlic, Sauce Soy, Chili Powder	NO	Mix togetjher, Soy Sauce, Chili Powder, Sherry, Honey, garlic. Pour into pan. Coat stir fry beef in cornstarch and lay flat in pan of mixture. Wait until mixture begins to bubble around strips before flipping. Mix in Carrotss and Green Onion.
59	Moo Goo Gai Pan	Pork	Porkchops			Stir Fry Veggies	Rice, Water Chestnuts	Garlic Powder, Onion Powder, Sauce Oyster, Sesame Oil, Sauce Soy	NO	Mix together Powder Garlic, Soy Sauce, Oyster Sauce and pan cook pork with veggies adding Sesame Oil to pan.
60	Oktoberfest Bowl	Deli	Bacon, Bratwurst		Carrots, Onion Purple, Potatoes			vinegar apple cider, Sauce Mustard Dijon, Garlic Powder, Parsley, Beer (Lager)	NO	Add to CROCKPOT: Bacon, Bratwurst, Carrotss, Onion Purple, Potatoes, vinegar apple cider, Mustard Dijon, Garlic Powder, Beer (Lager). Cook on low 6-8 hours, high 4-6 hours. Top with parsley.
61	Parmesan Crusted Tialpia	Seafood		Shredded Parmesan		Tilapia		Onion Powder, Celery Salt, Pepper, Basil, Sauce Mayo, Butter	YES	Mix together cheese, butter, mayo, basil, pepper, onion powder, celery salt together. Spread mixture over fillets and bake until fish flakes and topping browning. Rotate pan halfway through.
62	Pesto Chicken Pasta	Poultry	Chicken Breasts		Tomato		Noodles Spirals/Shells	Butter, Pesto	YES	Boil noodles until tender. Melt Butter in pan, add Chicken Breasts until fully cooked. Add chopped tomato and pesto and mix well. Serve over noodles.
63	Pork Kale Salad	Pork	Pork Tenderloins	Milk, Swiss Shredded	Kale, Radishes		Beets, Sunflower Seeds	Butter, Juice Lemon, Mustard Dijon, Garlic, vinegar basalmic, olive oil	NO	Preheat oven to 400*. Season pork tenderloins with dill, Garlic, and Onion. Trim edges of radishes and cut in half. Remove the centers of the kale. Roughly chop leaves. Drizzle beets and radishes with oil and dill, Garlic, Onion. Stir everything until coated. Spread radishes and beets on foil covered pan and roast for 15 minutes. Massage kale with creamy-lemon dijion sauce(Juice Lemon, Garlic, vinegar basalmic, olive oil, Mustard Dijon, salt and pepper) and lightly season with salt. Add pork to preheated oiled pan. Sear 3 minutes on each side then transfer to the oven and bake for 10 minutes. Cut pork and create the salad. Toss together the kale, roasted beets and radishes, and sunflower seeds. Sprinkle swiss on top, drizzle with any remaining sauce, and place slices of pork on top.
64	Pork Roast	Pork	Pork Roast		Onion Purple, Potatoes		Tomato Sauce	garlic, Sauce Soy	NO	Add all items to CROCKPOT and cook on low 8 hours, high 6.
65	Pork Sausage Skillet	Pork	Pork Sausage	Ricotta, Mozzarella Shredded	Onion White, Broccoli			Sauce Worcestershire, Italian Blend Seasoning, Vinegar Basalmic, Sauce Gochujang, Olive Oil	NO	Cook Sausage in oven safe pan and preheat oven to 350*, add cut broccoli and Onion, season with Italian Blend Seasoning once sausage cooked, stir until fragant. Add roasted red pepper sauce (basalmic, gochujang), olive oil, and ricotta. Add 1/4 cup water and sitr until fully mixed and heated. Remove from heat, top with mozzarella evenly and bake in oven until mozzarella crisps.
66	Ravioli Skillet	Poultry	Chicken Ravioli	Mozzarella Shredded, Milk	Onion Purple, Spinach, Tomato			Garlic Powder, Butter	NO	Cut veggies. Boil the raviolis. Cook Onion in pan until fragarant, add tomatoes and butter/milk mix and Garlic Powder, stirring together. Add Raviolis to pan once tender, and sprinkle with spinach, cover and let simmer. Top with shredded mozzarella.
67	Roast	Beef	Beef Chuck Roast		Carrots, Potatoes			Beef Gravy (Powdered)	NO	Place chuck roast, fresh Baby Carrotss, & Potatoes in CROCKPOT, stir in Gravy & hot Water mix until it rises just above the Veggies & Meat. Heat on high for 6 hours. Low for 8. Pull apart the Meat after the 4th (6th) hour to get the Gravy soaked into the Meat for the remaining time.
68	Roast with Chive Potaoes	Beef	Stew Beef		Mushrooms, Onion Green, Potatoes		Broth Beef	Beef Gravy (Powdered), Butter, garlic, Sauce Worcestershire	NO	Toss all ingredients into CROCKPOT and cook high for 6 hours, low for 8.
69	Sausage Beans & Rice	Deli	Polska Sausage				Beans, Rice, Tomato Sauce	Sauce Soy	NO	Add Sliced sausage (polska Beef/Turkey), canned Beans, Tomato paste/Sauce to CROCKPOT & heat on high for 4 hrs. Top over prepared Rice.
70	Sausage Eggs & Rice	Deli	Polska Sausage, Eggs				Rice	Sauce Soy	NO	prepare Rice. Cook Eggs according to taste, cook sausage in pan with Soy Sauce.
71	Scallops Carbonara	Seafood		Parmesan Shredded	Onion Green	Scallops	Bacon Bits, Noodles Spaghetti, Soup Cream Mushroom	garlic, Butter	YES	Boil noodles until tender. Melt Butter and garlic in pan, add Soup Cream, chopped green Onion, and scallops. Mix together items, and top with bacon bits and Cheese.
72	Seafood Boil	Seafood			Corn Cobbed, Potatoes	Shrimp, Crab Legs		Butter, Old Bay, Juice Lemon	NO	Toss Oil, Butter, Old Bay, and Salt with medallion Potatoes and Shrimp. Bake in "individual meal" foils at 425* for 30 minutes
73	Sesame Pork Roast	Pork	Pork Roast		Onion Green		Honey, Sesame Seeds White	Sauce Soy, Vinegar White Wine, Cayenne Pepper, Garlic Powder, Cornstarch		Cut roast in half. In a separate bowl or shallow dish, combine the water, soy sauce, sesame seeds, molasses, vinegar, onions, garlic powder and cayenne. Pour half over the cut roast. Cover and refrigerate roast and remaining marinade overnight. Drain roast, discarding marinade. Place roast in a 5-qt. slow cooker; add the reserved marinade. Cover and cook on high for 1 hour. Reduce temperature to low; cook until meat is tender, 8-9 hours longer. Remove meat to a serving platter; keep warm. Skim fat from cooking juices; transfer to a small saucepan. Bring liquid to a boil. Combine cornstarch and cold water until smooth. Gradually stir into the pan. Bring to a boil; cook and stir until thickened, 2 minutes. Serve with meat. If desired, sprinkle with additional sesame seeds.
74	Shepherd's Pie	Beef	Ground Beef		Onion Purple	Mixed Veggies	Broth Beef, Mashed Potatoes	Garlic Powder	NO	Brown Ground Beef with Garlic and Onion. Add Broth and Veggies until well mixed. Make Mashed Potatoes as directed. Layer Ground Beef mix first, then top with Mashed Potatoes. Bake together at 350* for 25 minutes
75	Shrimp Victoria	Seafood			Mushrooms, Onion Purple	Shrimp	Noodles Spaghetti	Garlic Powder, Sauce Worcestershire, Butter	YES	Saute mushrooms with Butter, Garlic Powder, and Onion until golden. Pan fry shrimp with saute. Boil Noodles. Combine together and top with green Onion.
76	Sloppy Joe Pie	Beef	Ground Beef		Tomatoes, Onion White, Bell Pepper Green		Pillsbury Biscuits		YES	Brown Ground Beef, add sloppy joe Sauce to the Ground Beef. Press out Pillsbury Biscuits into oven pan and fill. Press out and Pinch top onto pie. Bake @ 375* for 30 minutes.
77	Smoky Pork Kale Salad	Pork	Porkchops	Shredded Parmesan, Sour Cream	Kale, Mushrooms, Onion Purple		Almonds, Cranberries	Paprika, Onion Powder, Brown Sugar, vinegar basalmic, Olive Oil	NO	Coat Porkchops with Paprika, Onion Powder, and Brown Sugar. Cook in pan and remove once finished. Add mushrooms and Onion to pan and season with Paprika, Onion Powder, and Brown Sugar, cook until carmelized. Combine together, vinegar basalmic, olive oil, and sour cream. Drizzle over kale, sprinkle salt, and massage leaves until softened. Top Mushrooms and Onion over Kale, add cranberries and parmesan, stir together until well mixed. Divide salad between plates and top with Porkchops. Drizzle with viniagrette on top and sprinkle more Shredded Parmesan.
78	Spagehtti	Beef	Ground Beef				Noodles Spaghetti, Ragu	Dressing Italian Mix, Garlic Powder, Onion Powder, Butter, garlic	Salad	Brown Ground Beef in medium pot, add Garlic, Onion, Dressing Italian Mix & Salt to taste, after Meat has browned, add Tomato Sauce, cook until hot; Boil noodles and drain, put Noodles back in pot & add spoonful of Butter & Powder Garlic, mix well.
79	Spicy Garlic Shrimp	Seafood			Onion Green	Shrimp		Onion Powder, Butter, Cayenne Pepper, Juice Lemon, Garlic Black	YES	Melt Butter in pan, add Juice Lemon, garlic, Garlic Powder, Onion Powder, cayenne pepper and green Onion until well mixed. Add shrimp and cook until done. (replace Garlic with Garlic Black)
80	Steak in Mushroom Sauce	Beef	Steak Ribeye		Mushrooms, Onion Purple			Butter, Demi-glace, Sauce Mustard Dijon,	YES	Cook steaks as desired. Add Butter, Mushrooms, and Onion to pan and cook until softened, add demi-glace and 1/4 cup water. Bring to a gentle boil, then add mustard and let simmer. Return steaks to pan and coat well, serve and top with any remaining sauce.
81	Sticky Garlic Sesame Chicken	Poultry	Chicken Breasts		Onion Green		Honey, Sesame Seeds White	Garlic Powder, Sauce Gochujang, Onion Powder, Sesame Oil, Sauce Soy	YES	Mix together Soy Sauce, Honey, Powder Garlic, Powder Onion, and GoChuJang together. Soak chicken in mixture for at least 30 minutes before cooking. Add seasme oil and vodka to pan and sautee chicken and sauce together. Add chopped Green Onion and Sesame Seeds White before serving.
82	Stir Fry (Beef, Chicken, Pork)	Multi-Meat	"Meat"			Stir Fry Veggies	Baby Corn, Rice, Sesame Seeds White	Japanese Pepper, Sesame Oil, Sauce Soy	NO	Marinate Meat in Soy Sauce. Prepare Rice. Pan fry meat, adding vodka and sesame oil to the pan. Once meat is cooked, add in vegetables. Add prepared Rice or ramen in after and mix well. Top with Sesame Seeds White if desired.
83	Stroganoff	Beef	Ground Beef	Parmesan Shredded, Sour Cream	Mushrooms, Tomatoes		Noodles Spirals/Shells, Broth Beef	Butter, Garlic Powder, Onion Powder, Parsley, Sauce Worcestershire	NO	Add all items to CROCKPOT (except Cheese) and cook on low 8 hours, high 6.
84	Sweet & Sour Chicken	Poultry	Chicken Breasts				Breadcrumbs, Sesame Seeds White	Sauce Sweet & Sour, Sauce Soy	Fried Rice	Coat Chicken in Bread Crumbs, add small amount of Oil to the pan & gently place Chicken Strips in pan. Fry each side until browned. Add Sweet & Sour Chicken to the pan & flip Chicken pieces in the Sauce until sticky. (optional: add Sesame Seeds White to chicken before serving over Rice)
85	Sweet & Spicy Pork	Pork	Porkloin					Sauce Gochujang, Sauce soy, Brown sugar, garlic	YES	Slice pork loin thinly. Soak pork in sauce (gochujang, soy, brown sugar, and garlic) for at least 1 hour prior to cooking. Sear in pan on each side getting the golden brown carmelizing on the meat.
86	Taco Soup	Beef	Ground Beef	ColbyJack Shredded	Onion Purple, Tomato		Beans, Broth Beef, Noodles Spirals/Shells, Salsa Picante	Garlic, Chili Powder, Cumin	NO	CROCKPOT: Toss all items in and heat on Low 8 hours, High 6 hours.
87	Terriyaki Salmon	Seafood				Salmon		garlic, Sauce Garlic Hoisin, Sesame Oil, Sauce Terriyaki	YES	Mix together garlic, Sesame Oil, Terriyaki, Garlic Hoisin, and Sherry. Allow meat to marinate 20 minutes. Bake @ 400* for 15 minutes. Using the remaining marinade, heat in sauce pan until thickened. Pour sauce over fish once completed.
88	Thai Coconut Shrimp Soup	Seafood		Coconut Milk	Bell Pepper Red, Onion Green, Onion White, Mushrooms Shiitake	Shrimp	Broth Veggie, Sesame Seeds Black	Crushed Red Pepper, Fish Sauce, Juice Lime, Lemongrass	NO	Blend together ginger and chopped white Onion. Chop mushrooms and let soak with warm water. Slice scallions and finely chop red pepper. Using soup pot, make vegetable Broth (vegetable Broth, lemongrass, Juice Lime, fish sauce.) Rinse shrimp and pat dry. Cook in frying pan until turning pink. Season shrimp with salt and pepper. Add ginger and Onion mix and red peppers. Stir veggies and shrimp together. Season gently with red pepper flakes. Once peppers are softened, add the mushrooms and soaking water. Add everything from the pan to the vegetable Broth pot, and stir together. Once thoroughly heated, add the coconut milk and stir. Bring to a boil for 5 minutes until shrimp is fully cooked. Garnish servings with Sesame Seeds Black, Scallions, and Crushed Red Pepper.
89	Tilapia	Seafood				Tilapia		Butter, Lemon Pepper, Juice Lemon	Squash Yellow, Green Beans, Baked Potatoes	bake as instructed, add Juice Lemon, melted Butter, & Lemon Pepper over fillets
90	Unstuffed Peppers	Beef	Ground Beef		Tomato, Onion Purple		Rice	Cayenne Pepper, Paprika	NO	Prepare Rice. Brown ground beef and mix together with tomato, Onion soup mix, and cayenne pepper. Mix with prepared Rice.
91	Veggie Marinara Pasta	Beef	Ground Beef	Mozzarella Shredded	Carrots, Squash Zuchini, Tomatoes		Noodles Spirals/Shells	Italian Blend Seasoning, Garlic Powder	NO	Boil noodles. While browning the ground beef, Add to BLENDER: 1/4 cup water, Italian Blend Seasoning, Garlic, 1 cup of chopped Carrotss, 1 Zuchini Squash chopped - Turn wheel to HEATED PUREE and press to start; once it's done press cancel, strain can of tomatoes before adding to sauce (be careful the sauce and container will be HOT), and replace the lid, setting to CUSTOM BLEND for 30 seconds. Strain pasta, top with sauce, ground beef, and sprinkle with mozzarella.
92	White Bean Chili	Poultry	Chicken Breasts		Tomato		Beans, Broth Chicken, Green Chilis	Garlic Powder, Onion Powder	NO	INSTANTPOT Chicken. Add shredded chicken, Potatoes, Celery, Chicken Stock, Beans, and Green Chilis. Season with Salt, Powder Onion, and Powder Garlic.
93
94
95
96	89
97		Meat	Stew Beef, Porkloin, Chicken Breasts, Ground Pork, Ground Beef, Meat, Eggs, Turkey Breast, Chicken Breast, Ground Turkey, Bacon, Porkchops, Polska Sausage, Stir Fry Beef, Bratwurst, Pork Tenderloins, Pork Roast, Pork Sausage, Chicken Ravioli, Beef Chuck Roast, Steak Ribeye, "Meat"
98			Dairy	Mozzarella Shredded, bleu cheese, Sour Cream, ColbyJack Shredded, Milk, Cheddar Shredded, Cream Cheese, whipping cream, Crème Fraiche, Cotija, Parmesan Shredded, Swiss Sliced, Shredded Parmesan, Swiss Shredded, Ricotta, Coconut Milk
99				Fresh Produce	Carrots, Celery, Mushrooms, Onion Green, Potatoes, Onion Purple, Cucumber, Lettuce, Tomato, Avocado, Tomatoes, Bell Pepper Red, Broccoli, Jalapenos, Onion White, Bell Pepper Orange, Cabbage, Tomato Grape, Lime, Squash Butternut, Leeks, Apple Red, Squash Yellow, Bell Pepper Green, Kale, Radishes, Spinach, Corn Cobbed, Mushrooms Shiitake, Squash Zuchini
100					Frozens	Mixed Veggies, Burgers Frozen, Cod, Shrimp, Salmon, Tilapia, Crab, Hashbrowns, broccoli, Stir Fry Veggies, Scallops, Crab Legs
101						Packaged & Canned (Dry)	Beans, Beans Refried, Noodles Lasagna, Broth Beef, Mashed Potatoes, Noodles Spirals/Shells, Rice, Sesame Seeds White, Buns Burger, Pickles, Salsa, Tortillas/Taco shells, Broth Chicken, Pillsbury Biscuits, Tortillas, Green Chilis, Chips Tortilla, Corn, Broth Veggie, Rice Wild, Chips Frito, marsala wine, Hazelnuts, Pepitas, honey, tomato soup, Soup Cream Mushroom, Tomatoes Diced Fire Roasted, S&B Curry Powder 3 tbsp, Broth Chicken 3cups, Tomato Paste 1tbsp, Baby Corn, Water Chestnuts, Almonds, maple syrup, Breadcrumbs, Tomatoes Diced, Beets, Sunflower Seeds, Tomato Sauce, Bacon Bits, Noodles Spaghetti, Cranberries, Ragu, Salsa Picante, Sesame Seeds Black
102							Condiments & Spices	Garlic Powder, Onion Powder, Beef Gravy (Powdered), Parsley, Brown Sugar, garlic, Sauce Buffalo, Sauce Bulgogi, Sauce Gochujang, Sauce Mayo, Sauce Mustard, Sauce Ketchup, Taco Seasoning Mix, butter, olive oil, cajun seasoning, Flour, Italian Blend Seasoning, Onion Soup Mix, Sauce Soy, Sesame Oil, Fried Rice Seasoning, Garlic Onion, Sauce BBQ, Dressing Ranch, cayenne pepper, Juice Lime, Crushed Red Pepper, HERBS?, Juice Lemon, Cumin, Basil, vinegar red wine, Sauce Lemon Butter Dill, 1/4 cup dry sherry, ginger, sauce chili garlic, sesame seeds, Sauce Oyster, Thyme, Tumeric, vinegar white, cornstarch, gochujang, Sauce Chunou 2tbsp, cocoa powder1tspn, Sauce Korean BBQ, Dressing Italian Mix, lemon juice, salt, Lemon Pepper, Vinegar White Wine, dijon mustard, Chili Powder, vinegar apple cider, Sauce Mustard Dijon, Beer (Lager), Celery Salt, Pepper, Pesto, Mustard Dijon, vinegar basalmic, Sauce Worcestershire, Old Bay, Paprika, Garlic Black, Demi-glace, Japanese Pepper, Sauce Sweet & Sour, Sauce Garlic Hoisin, Sauce Terriyaki, Fish Sauce, Lemongrass
Sheet1

Cell Formulas
Range	Formula
A96	A96	=SUBTOTAL(103,[Course])
C97	C97	=LET(Joined,","&TEXTJOIN(",",TRUE,'[Meals 2.0.xlsx]Dinner Recipes'!C4:C95)&",",Parts,REPLACE(Joined,1,FIND("#",SUBSTITUTE(Joined,",","#",SEQUENCE(LEN(Joined)-LEN(SUBSTITUTE(Joined,",",""))-1))),""),TEXTJOIN(", ",,UNIQUE(TRIM(LEFT(Parts,FIND(",",Parts)-1)))))
D98	D98	=LET(Joined,","&TEXTJOIN(",",TRUE,'[Meals 2.0.xlsx]Dinner Recipes'!D4:D95)&",",Parts,REPLACE(Joined,1,FIND("#",SUBSTITUTE(Joined,",","#",SEQUENCE(LEN(Joined)-LEN(SUBSTITUTE(Joined,",",""))-1))),""),TEXTJOIN(", ",,UNIQUE(TRIM(LEFT(Parts,FIND(",",Parts)-1)))))
E99	E99	=LET(Joined,","&TEXTJOIN(",",TRUE,'[Meals 2.0.xlsx]Dinner Recipes'!E4:E95)&",",Parts,REPLACE(Joined,1,FIND("#",SUBSTITUTE(Joined,",","#",SEQUENCE(LEN(Joined)-LEN(SUBSTITUTE(Joined,",",""))-1))),""),TEXTJOIN(", ",,UNIQUE(TRIM(LEFT(Parts,FIND(",",Parts)-1)))))
F100	F100	=LET(Joined,","&TEXTJOIN(",",TRUE,'[Meals 2.0.xlsx]Dinner Recipes'!F4:F95)&",",Parts,REPLACE(Joined,1,FIND("#",SUBSTITUTE(Joined,",","#",SEQUENCE(LEN(Joined)-LEN(SUBSTITUTE(Joined,",",""))-1))),""),TEXTJOIN(", ",,UNIQUE(TRIM(LEFT(Parts,FIND(",",Parts)-1)))))
G101	G101	=LET(Joined,","&TEXTJOIN(",",TRUE,'[Meals 2.0.xlsx]Dinner Recipes'!G4:G95)&",",Parts,REPLACE(Joined,1,FIND("#",SUBSTITUTE(Joined,",","#",SEQUENCE(LEN(Joined)-LEN(SUBSTITUTE(Joined,",",""))-1))),""),TEXTJOIN(", ",,UNIQUE(TRIM(LEFT(Parts,FIND(",",Parts)-1)))))
H102	H102	=LET(Joined,","&TEXTJOIN(",",TRUE,'[Meals 2.0.xlsx]Dinner Recipes'!H4:H95)&",",Parts,REPLACE(Joined,1,FIND("#",SUBSTITUTE(Joined,",","#",SEQUENCE(LEN(Joined)-LEN(SUBSTITUTE(Joined,",",""))-1))),""),TEXTJOIN(", ",,UNIQUE(TRIM(LEFT(Parts,FIND(",",Parts)-1)))))

 

[Fluff]

I'm a bit unsure of what you are looking to do, could you post some data showing the output you want

 

[Fluff]

If you are looking to have each item in it's own cell, how about

=UNIQUE(FILTERXML("<k><m>"&SUBSTITUTE(TEXTJOIN(",",TRUE,C4:C95),",","</m><m>")&"</m></k>","//m"))

This will only work on a PC

 

[nputt]

YOU HAVE SOLVED ALL OF MY PROBLEMS!! THANK YOU!!!

 

[Fluff]

You're welcome & thanks for the feedback.

 

[nputt]

If you are looking to have each item in it's own cell, how about

=UNIQUE(FILTERXML("<k><m>"&SUBSTITUTE(TEXTJOIN(",",TRUE,C4:C95),",","</m><m>")&"</m></k>","//m"))

This will only work on a PC

Actually, one minor problem

For columns G & H, they aren't calculating correctly. Any suggestions?
I tried to attached the excel spreadsheet but it was "too large" to post

 

[Fluff]

You have & signs in there which is causing the problem, try

=UNIQUE(FILTERXML("<k><m>"&SUBSTITUTE(SUBSTITUTE(TEXTJOIN(",",TRUE,C4:C95),"&","&amp;"),",","</m><m>")&"</m></k>","//m"))

Also in H22 you have a comma at the end of the string which will return a #VALUE! error in the list