How to use Multi-Row Formula but instead of IsNull, the test is if row has leading spaces?

[maddada]

Hi everyone!

I just wanted to know if I can use the Multi-row function if I am not testing if the row is null, but instead if the row has leading whitespaces.

My data has sub-headers for each region, and I want to add the sub-header on the regions to differentiate them per sub-header.

I want them to become Revenue Asia, Revenue Canada, Revenue U.S. and Net Income Asia, Net Income Canada, Net Income U.S.

As you can see on the screenshot, my condition is not that they are null, but they have leading whitespaces.

Let me know if another function is better to use in this situation than the multi-row function. Screenshots of used formulas and functions to solve this are very much appreciated. Thank you!

[BS_THE_ANALYST · Accepted solution]

@maddada I would approach it like this, assuming they may not always have trailing spaces, and when they do, what if they have multiple etc. This will cater for that. 

Step 1: setup problem

Step 2: extract headers (this is where you can pull out the headers based on logic)

Step 3:
Concatenate headers and subheaders:

Step 4: Filter:

[maddada]

Woooaaah! I didn't think of doing it that way. Thank you so much for this! 🤓

[BS_THE_ANALYST]

@maddada that's the beautiful thing with Alteryx, there's so many ways to do things 😎. 

All the best,
BS