I have a data flow that has multiple properties and competitors. I was looking for a way to label all of the records that are in between into one property. In the example sheet that i uploaded, I was wondering if a beast mode formula could be used to rows 3-16 are labeled as the property Brandon crossroads in this case. Using Magic ETL is also an option. I just don't see how I could pivot and unpivot properly.
I am attempting to change sheet 1 into sheet 2 in reality.
I have looked at a few ways to do this but I don't see any native functions or etl flow that would be easily applicable. If I was in Python I could use fill. My only other option is to lag it and fill it off the lagged value that has text and then repeat the process.