Sorting data by a particular value then group by another

DS1810

Dear all,

I have this data list that now is sort by "transaction number" column A. Each transaction number is a set of data that always need to be grouped together. In total there are 4 sets of data as below.

Now i wish to sort the 4 data sets, in the order that the amount of account # 112101 is ascending.

In other words, if you look at column C, there is this account numbered 112101, and it's value is in the same row under column F. I want this account's amount to be sort in ascending order, however, to keep the data sets still in it's own group.

The desired output would be:

In this case, the account 112101 is in ascending order (-1234056.95 < -199999 < -40000 <-12748.07), but the data are still grouped as by the transaction number.

Appreciate if anyone can help!!!! 😁

ALTERYX - SORT BY A SPECIFIC FIELD AND EXPAND DATA.xlsx

atcodedog05

Hi @DS1810 

Here is how you can do it.

Workflow:

1. Using filter to get only 112101 values.

2. Using find and replace and adding 112101 amount values to all rows of its respective transition. This way transactions can be sorted by 112101 amt.

3. Sorting on 112101 amount ascending, transaction number ascending and acct ascending.

Hope this helps : )

112101.yxmd