Sorting and displaying columns by specific criteria

[JananiLakshmikumar]

I have an excel sheet with different tax category columns and gross and net amount columns. I want to sort data dynamically so that all the tax categories are shown next to each other and then the gross and net amount columns. Can some one help me with this?

[CoG · Accepted solution]

I'm not quite sure if this is what you're looking for, but this workflow sorts columns (in this case tax columns first, then Gross and Net):

[binu_acs · Accepted solution]

@JananiLakshmikumar Another method, make sure the unknown column in the select tool is before the net and gross columns

[JananiLakshmikumar]

Thanks Andrew this did work,

[JananiLakshmikumar]

Thanks Binuacs I moved the unknown field above Gross and this helped.