Unable to Sort

[ArijitRoy]

Hi Team,

I have attached an excel file. First sheet (Data) is the input file and next sheet is the way I am looking for. In the sheet1 Line1 column have same address but line 2 have 2 JPMC number. So, Kindly check the Sheet2 the way I am looking for.

[PhilipMannering]

You should just be able to sort on column 2 (Ship to Site Address Line 4) - or Line 2 as you call it - ascending to get your desired output.

[ArijitRoy]

Hi, I need the sorting on the basis of (Ship to Site Address Line 1).

[PhilipMannering]

Then sort by [Address Line 1] and [Address Line 2], but you would need to remove the " Total" bit from [Address Line 1] first. (you can add it back after the sort).

[MilindG]

@ArijitRoy 

[ArijitRoy]

Sorry guys for late reply. Previously I shared small data but this time I am sharing much more data. 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.