Sort columns not complete tabel

[ferha_jafri]

Hello Experts,

I have scenario where I want to sort columns not table, in the input data I have country column corresponding to sale column, and I want to sort Country as per Sales sort. I the attached excel Sheet1 is the input and output has the desired output.

Thanks

[Christina_H]

Use a select tool to separate the columns you want to sort, then rejoin by position.

(The select tool isn't strictly necessary since join has an embedded select, but makes it easier to see what's happening)

[ferha_jafri]

But on what basis you will join as if you do it on the basis Country it will disturn the sort order.

[Christina_H]

@ferha_jafri See option top left of previous image - select Join by Record Position

[HomesickSurfer · Accepted solution]

Hi @ferha_jafri 

Here's a solution to consider, without joining fields:

Workflow attached.