Sorting rows

[ashlad75]

Hi

I have just started using excel and im a little confused with the sorting functions.
I have one row of album titles and one row with track number and titles.

I want to sort this so that the track number starts on 01 for each album like ive manually done in the picture


2021-02-27.png

Can this be done automatically?

[Glenn Kennedy]

Select all 3 columns.

data/Sort/Sort by "Column A"/add a level/sortby "Column B"/OK.

Job done.

[ashlad75]

Thank you

[Glenn Kennedy]

You're welcome.

---

It would be very nice if you were to just click the Add Reputation button at the foot of any of the posts of members who helped you reach a solution.

Finally, if that takes care of your original question, please select "Thread Tools" from the menu link above and mark this thread as SOLVED.