Sorting and displaying columns by specific criteria

Question

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?

Example.xlsx

CoG · Accepted Answer

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 Answer

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