How to re arrange the fields in a column?

[Siddarth]

Hi i have a table in Ex code Group Column fields are arranged in ascending order which is to be arranged into dynamically. How can i do that?

[wwatson]

I'm not sure what you mean by Arranged Dynamically. 

can you explain or provide a sample of how you want the output to look?

[wdavis]

Hi @Siddarth 

I have attached a workflow which I think addresses your issue. As @wwatson says, if you're able to provide a bit more context then we can help with the building of the workflow.

In the example, you are able to Transpose all Fields into one column, sort them based in ascending order and then use the Cross-Tab to put them back into the original format.

Let me know if this helps!

Will

[Siddarth]

Hi @wwatson,

My Excode Column is already arranged in ascending order as Carhaul , Damage , FTC Hold... so on.

I need to change the the order of Excode in the order as Sales, Quality, Carhaul, Damage, Spotbuy and so on. 

This order does not allow show in ascending or descending order.

[wwatson]

The sort tool allows you to choose how to sort by columns. Each column can be sorted ascending or descending.

[wwatson · Accepted solution]

I suspect you need another column to sort by. Perhaps a formula like

if [ExCode]="Sales" then 1

elseif [ExCode]="Quality" then 2

elseif [Excode]="Carhaul" then 3

.

.

.

endif

The sort by the formula column.