Column A has a collection of team names. Each team has its list of items it uses.
Report comes in such format that: the cells in column A are merged as one cell for Each team.
1. First un-merge the column A
2. team names repeat for each cell underneath them, till they find another team name string
FYI: Dealing with 40000 rows of this data type. So fastest way is much preferred
Visualize your data even better in Access queries. Given a date and a value, this lesson shows how to compare that value with the previous value, calculate the difference, and display a circle if the value is the same, an up triangle if it increased…