Multi-Row Formula help

[dataviolet]

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?

[atcodedog05 · Accepted solution]

Hi @dataviolet 

Formula would be 

IF left([field],1)="F" then [row-1:output] else [field] endif

Lets me prep a example🙂

[atcodedog05]

Hi @dataviolet 

Here is a workflow for the task.

Output:

Formula:

IF Left([Name],1)="F" THEN [Row-1:Output] ELSE [Name] ENDIF

Workflow:

Hope this helps 🙂 Feel to ask if you have any questions

If this post helps you please mark it as solution. And give a like if you dont mind 😀👍

[dataviolet]

awesome, thank you so much! I was overcomplicating this in my head.

[atcodedog05]

Happy to help 🙂 @dataviolet 

Cheers and Happy Analyzing 😀

Feel free to reach out if you face any issues 🙂