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 · Accepted solution]

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 😀👍

[Emil_Kos · Accepted solution]

Hi @dataviolet,

I have created a workflow for you:

Please mark as a solution if it is helpful.

[dataviolet]

Thank you for the fast solution. Looks like I was just missing a section to my formula--forgot the "else" part:

IIF(isempty([Column1]),[Row-1:Column1],[Column1])

[atcodedog05]

Hi @dataviolet 

My solution is also same and i posted first why didnt you mark my post as solution.

My formula is also same IIF(isempty([Column1]),[Row-1:Column1],[Column1])

and i added Trim to remove blank spaces as a extra safety measure.

Asking out of curiosity 

[dataviolet]

I appreciate your assistance! Your solution worked too, but was confused about the necessity of the TRIM function used:

IIF(isempty(Trim([Field1]," ")),[Row-1:Field1],[Field1])

I thought the simpler method was without the TRIM

[atcodedog05]

Hi @dataviolet 

Trim([column]," ") is used a safety measure to remove blank spaces just in case you have multiple spaces

(like "  ") as blank.

Just be on a safer side🙂

You are allowed to mark multiple post as solution so please mark mine also if you dont mind 🙂

[dataviolet]

thank you for the explanation! that makes sense--in fact, i did have to use a data cleanse tool prior to this multi-row function, but now with the TRIM function, looks like I can get rid of the data cleansing tool.

[atcodedog05]

@dataviolet 

Yup thats the purpose to remove surrounding spaces

Happy to help 🙂

Cheers and Happy Analyzing 😀