Listng team-wise names from a list

Originally Posted by jsridhar

@bebo021999 Thank you. It works. Just one suggestion. In the Title Row, it lists IPL-D, IPL-C, IPL-B and IPL-A. Instead, if it lists from IPL-A to IPL-D, it would look better. Otherwise, it is fine. Thank you.

If you want to sort the header rows, there are several ways to do it depending on your data:
1- If your data is relatively stable, and the team list is fixed:
Method 1: Copy I3:L3, paste it transposed into another column, for example, N3:N6. Sort this range, and then copy-paste transpose it back into I3:L3.
Method 2: Sort column F. Then copy/paste the values in the header range I3:L3. Revert to sorting by column A.

2- If your data frequently changes, and the team list is regularly updated:
Method 1: Use an auxiliary column, like column G, to mark column F according to A-Z conditions. (like sample attached)
Method 2: In my opinion, the best approach is to use VBA. (will come back if you refer to VBA)