Forum Discussion

Cat_B91's avatar
Cat_B91
Copper Contributor
Mar 27, 2024

Alphabetize multiple seperate columns

I'm attempting to create a sheet of PLU's for our scales to print for display. I have Column A as Product, Column B is their PLU, Column C is more Product, and Column D is those PLU's.

I can't seem to get the columns to alphabetize together, not alphabetize in their separate columns. Is this not possible? 

Also, the numbers have to obviously stay with their product name, and I can't seem to select JUST Columns A & C to alphabetize, so idk if that is a problem. I am definitely not Excel savvy and YouTube has been little help in this case.

excel

3 Replies

    • Cat_B91's avatar
      Cat_B91
      Copper Contributor
      Mar 27, 2024

      Detlef_Lewin may I ask how to do that? And if I do, can I print it so that it's not one long list- we're talking upward of 400 lines if I do, which is why I was trying to put them side-by-side. 🤔 

      • Detlef_Lewin's avatar
        Detlef_Lewin
        Silver Contributor
        Mar 27, 2024

        Cat_B91 

        In that case you have to decide what is more important: sorting A-Z or printing over more than 2 columns.

         

Resources