Not able to sort

Question

Please check the attached file. I have applied subtotal on the basis of JPMC number and added a new row JPMC + Total word after the JPMC number. Every address can have 2 to 3 JPMC number.

That is why I have added Total word after JPMC number. Then I will add the total word on the Address line also and then I am going to remove the JPMC + Total from JPMC column.

Then short ascending as per the Address Line 1, but if one address line 1 have 2 JPMC number then the both the Total word going at the end of the Address line 1. That is the issue.

Check the attached file. Data sheet have the data and next sheet have the output that I am looking for. Later on I am going to remove whichever row have JPMC + Total.

Please let me know if you have any query.

Kindly help me the data from the Data sheet to sort Ascending. I have also shared the output in the Sheet1. In the the below picture there are 2 JPMC numbers on one address. So after first JPMC number "Address + Total" should come and then 2nd JPMC and then again "Address + Total".

Book3.xlsx

ArijitRoy · Answer

Never mind. I have solved it. Used Tiles tool.

caltang · Answer

@ArijitRoy , @apathetichell did not ask you remove the total... he's asking you to make a matching field (column) in Alteryx for your ease of reference. Whilst we understand you asked, you should be less snarky about your request.

ArijitRoy · Answer

First, I did not ask to remove the total from Address line 1.

I asked to sort the data in ascending order of the Data Sheet and should match like in the Sheet1.