Create categorize data with group names located at the bottom of the rows

[selsset97]

Hi Community,

Usually when we want to categorize groups from one column, we have the category names at the top of each category.

For example, using the Multi-Row Formula we can create the following category, using: IF Regex_Match([Dataset],"\u\l.*") THEN [Dataset] ELSE [Row-1:category] ENDIF

However, how can we create categories if category names are located at the bottom of the list?

For example:

In other words, if category names are located at the bottom of the rows of each category, is there a way to create the desired output column?

Thank you.

[grazitti_sapna · Accepted solution]

@selsset97 , One way of doing it.