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)
解決済! 解決策の投稿を見る。
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.
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 🙂