Add multiple Multi-Row Formulas - repeating labels

dataviolet

Hi all! I have data that looks like this:

Name 1	40
	44
Name 2	23
	25
Name 3	70
	76
Name 4	54
	45

I'm trying to get Alteryx to repeat the first column names--so it would end up looking like:

Name 1	40
Name 1	44
Name 2	23
Name 2	25
Name 3	70
Name 3	76
Name 4	54
Name 4	45

I think this would be done via a Multi-Row formula tool. However, my formula can only get it to repeat "Name 1" for every row, which isn't correct. Any ideas on how I can go about updating this correctly?

atcodedog05

Hi @dataviolet 

Here is a workflow for the task.

Input: As given

Output:

Workflow:

Hope this helps 🙂

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

fill.yxmd