Sort columns not complete tabel

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

Sort Sample.xls

Preparation

Accepted answers

HomesickSurfer

Hi @ferha_jafri

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

Workflow attached.

Sort_by_Column(field).yxmd

All comments

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

Hi @ferha_jafri

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

Workflow attached.

Sort_by_Column(field).yxmd

Quick Links

This months top contributors

atcodedog05 19598

Qiu 15878

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703