Hi all! I'm trying to build a multi-row formula to repeat some labels, but i'm running into an issue where the number of times a label should repeat is not consistent--sometimes it is 5 times, sometimes it is 6 times. Here is my data:
| What I have | What I want |
| Company1 | Company1 |
| F4 | Company1 |
| F5 | Company1 |
| F6 | Company1 |
| F7 | Company1 |
| Company2 | Company2 |
| F9 | Company2 |
| F10 | Company2 |
| F11 | Company2 |
| F12 | Company2 |
| Company3 | Company3 |
| F14 | Company3 |
| F15 | Company3 |
| F16 | Company3 |
| F17 | Company3 |
| Company4 | Company4 |
| F19 | Company4 |
| F20 | Company4 |
| F21 | Company4 |
| F22 | Company4 |
| F23 | Company4 |
| F24 | Company4 |
How do I change my multi-row formula in order to transform my data on the left to the data on the right?
