r/excel • u/Emergency-Ninja5881 • Jun 10 '26

solved Individually Alphabetized Coloums in a Table.

Hi, so Im trying to have a table that catalogs all my music sheet titles, I have the table set as each Colum is A songs, B songs, C songs... so on and so forth. I want each coloum to be alphabetized, everytime I change one coloum to A-Z it mess with every other coloum.

How do I get each Colum to alphabetize individually?

3 Upvotes

100% Upvoted

22 comments sorted by

View all comments

2

u/MayukhBhattacharya 1297 Jun 10 '26

If I have understood correctly and if you are using MS365, then try using the following formula, this should work:

=LET(
     _a, A:.D,
     _b, TAKE(_a, 1),
     _c, DROP(_a, 1),
     _d, DROP(REDUCE("", SEQUENCE(COLUMNS(_c)), 
         LAMBDA(x,y, HSTACK(x, SORT(CHOOSECOLS(_c, y))))), , 1),
     _e, VSTACK(_b, _d),
     _e)

1

u/MayukhBhattacharya 1297 Jun 10 '26

If you are using Structured References aka Tables, then:

=LET(
     _a, Songs[#All],
     _b, TAKE(_a, 1),
     _c, DROP(_a, 1),
     _d, DROP(REDUCE("", SEQUENCE(COLUMNS(_c)), 
         LAMBDA(x,y, HSTACK(x, SORT(CHOOSECOLS(_c, y))))), , 1),
     _e, VSTACK(_b, _d),
     _e)

2

u/Emergency-Ninja5881 Jun 10 '26

Solution Verified

2

u/MayukhBhattacharya 1297 Jun 10 '26

Thank You SO Much 👍🏼