How to define blank rows with what is there before it?

[Priyas_4525]

The data set has a column with company names and the form of growth they had (Organic, Product acquisition, total, etc.). I want to pull the company names in a separate column and also, the form of growth in a separate column.. even filling the ones with the blank cells after it with what's there at the top. Can we do this in Alteryx?

For instance, In Cells A3-A62, I want "Organic" and similarly "In-licensed" in A63 till the next head comes. Also, the company names like "AbbVie" pulled in separate column too. (we have multiple companies with the same data format)

[atcodedog05]

Hi @Priyas_4525 

It is possible with mutli-row formula tool can you share a sample data so that we can help you out with an example.

[Priyas_4525]

 See if it helps!

[atcodedog05 · Accepted solution]

Hi @Priyas_4525 

Here is how you can do it. 

Workflow:

If this doesnt meet the requirement please provide an expected output i can work towards it.

Hope this helps : )

[Priyas_4525]

Thank you! this works but can I also separate out the company names from the column?

[atcodedog05]

Happy to help : ) @Priyas_4525 

Cheers and have a nice day!

[Priyas_4525]

Yeah.. it would be really great if you can help me in separating the company names (AbbVie) into a separate column 🙂

[atcodedog05 · Accepted solution]

Hi @Priyas_4525 

Check whether does this work.

Workflow:

Hope this helps : )

[Priyas_4525]

Thanks.. it works 🙂