Specific order of rows

[Meoth]

Hi all,

Can anyone please help me in getting this particular order of rows?

Source image has been attached.Source image

Below is the needed result,

Result image

[DavidP · Accepted solution]

I would suggest creating a Row ID field to assign a row number based on the [US Filing Group] field (using an if elseif statement) and then sort on Row ID

[RolandSchubert · Accepted solution]

Hi @Meoth ,

you could create a Text Input with two fields ([US Filing Group] and [Order], containing the names in the column and the required sort order as a number), join this by [US Filing Group] to your data on  and sort by [Order]. What do you think?

Best,

Roland

[Jonathan-Sherman · Accepted solution]

Hi @DavidP,

In a similar fashion to @DavidP I would advise you use a reference table with a RowID and a find and replace tool to append these values before sorting. The reference table would mean you don't need to debug a messy formula if the number of "values" increases further.

Output:

Reference Table:

If this solves your issue please mark the answer as correct, if not let me know! I've attached my workflow for you to download if needed.

Regards,

Jonathan

[Meoth]

This worked really well. Thank you all for your help

[Piotr_O]

Thank you Jonathan-Sherman, your solution came in handy.

Regards,

Piotr