I a beginner/Intermediate user to Alteryx. have a set of data where I need to create a new column "country" based on data in the next row below where the next row below contains the value 'country". The row below is not always Row+1. Attached is a sample input and desired output. I think a combination of Transpose/CrossTab/Multi-row formula can do this, but I am not sure how to write it. Thanks
Input:
Location Type | Location |
Building | Blue |
Building | Green |
Country | USA |
Building | Red |
Building | Orange |
Country | UK |
Building | Yellow |
Country | France |
Building | Black |
Country | Norway |
Building | Brown |
Building | Black |
Building | Cienna |
Building | Pink |
Building | Neon |
Country | Africa |
Desired Output:
Location Type | Location | Country |
Building | Blue | USA |
Building | Green | USA |
Country | USA | USA |
Building | Red | UK |
Building | Orange | UK |
Country | UK | UK |
Building | Yellow | France |
Country | France | France |
Building | Black | Norway |
Country | Norway | Norway |
Building | Brown | Africa |
Building | Black | Africa |
Building | Cienna | Africa |
Building | Pink | Africa |
Building | Neon | Africa |
Country | Africa | Africa |
Solved! Go to Solution.
Thank you so much! This works great.
Thank you so much @FinnCharlton. This solution is doable.