Alteryx - dynamically selecting filtering for certain rows based on text

[sislam11]

Hello,

Please could you help me to dynamically filter rows based on headings and text values. Please see attached file which has a tab with the input and another tab with the desired output.

In column1 we have the headings and text. Headings are in bold (e.g. Bananas, Oranges, Grapes, Apples). In column2 we have the values.

I would like to output only the "Example text two" and "Example text three" rows for "Bananas" and "Apples" along with the associated values.

The output should also append the heading to the example text.

It will need to be dynamic as the headings could be in different orders (e.g. Oranges could be first instead of Bananas)  but the text under each heading will remain the exact same.

I am having trouble as it would be easy if the text under each heading was different but now the text is the same under each heading.

Many thanks in advance!

[Carlithian]

Just checking, will there always be the null rows between each group? Or is it only the bolding that identifies a new grouping?

[Luke_C · Accepted solution]

Hi @sislam11 

You can leverage a multi-row formula tool to get the header info for each row:

[Felipe_Ribeir0 · Accepted solution]

Hi @sislam11 

One way of doing this

[sislam11]

There could no null rows in between however the headings will always be the same (i.e. Bananas, Apples, Oranges etc)