Data Transform Stacked Field to Columns

[w_gore]

I could use some help with transforming the example below from screenshot 1 to screenshot 2.  My data generates in a layout where company 1 has a row heading, followed by table data and repeats for company 2...company 3....I want the applicable company to appear as part of each row record. Thanks for the help.

Screenshot 1

Screenshot 2

[IraWatt]

Hey @w_gore,

To do this you would use the Multi Row Formula Tool:

IF Contains([F1], "Company") THEN [F1] ELSE [Row-1:New Field] ENDIF

The formula used in the tool checks to see if the column contains Company If it does it will use that value else use the value it was already using. If you want to learn more about the Multi-Row-Formula Tool the community has some quick and easy videos on the topic here: https://community.alteryx.com/t5/Interactive-Lessons/Multi-Row-Formula/ta-p/82872 

Any questions or issues please ask

Ira Watt
Technical Consultant
Watt@Bulien.com