Victtor
Board Regular
- Joined
- Jan 4, 2007
- Messages
- 170
- Office Version
- 365
- Platform
- Windows
in Column A I have several categories.
Chefs Features
Entree2-Mindful
Accompaniments
STG/LTO
(just to name a few)
Are a few of these categories. After EACH category, there are 4 items (all in Column A)
Is there a formula to extract all the data in the cells beneath each category? For this purpose lets say that there are 3-5 cells beneath each category.
Chefs Features
1
2
3
4
Entree2-Mindful
1
2
3
4
Accompaniments
1
2
3
STG/LTO
1
2
Chefs Features
Entree2-Mindful
Accompaniments
STG/LTO
(just to name a few)
Are a few of these categories. After EACH category, there are 4 items (all in Column A)
Is there a formula to extract all the data in the cells beneath each category? For this purpose lets say that there are 3-5 cells beneath each category.
Chefs Features
1
2
3
4
Entree2-Mindful
1
2
3
4
Accompaniments
1
2
3
STG/LTO
1
2