Copy data from variable row below based on criteria

[dgaines1972]

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

[FinnCharlton]

Hi @dgaines1972 ,

This is one way to do this:

[binu_acs · Accepted solution]

@dgaines1972 One way of doing this

[dgaines1972]

Thank you so much!  This works great.

[dgaines1972]

Thank you so much @FinnCharlton.  This solution is doable.