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

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)

Datasets

Accepted answers

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 : )

Hi @Priyas_4525

Check whether does this work.

Workflow:

Hope this helps : )

All comments

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.

See if it helps!

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 : )

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

Happy to help : ) @Priyas_4525

Cheers and have a nice day!

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

Hi @Priyas_4525

Check whether does this work.

Workflow:

Hope this helps : )

Thanks.. it works 🙂

Quick Links

Tags

This months top contributors

atcodedog05 19458

Qiu 15866

MarqueeCrew 13708

apathetichell 13703