smatterchu
New Member
- Joined
- Oct 10, 2012
- Messages
- 5
I have monthly reports that need to be sorted in an order other than ABC. I have the proper order of each product, and the list is 79 separate items/rows (over 2,500 characters). I tried to create/import a custom list and ran into the character limit.
How can I set up some sort of lookup table or data table to get these sorted properly? From the source data, I will be putting these into a pivot table. At what point, can I get these in the desired order?
Please use "small words" I'm just getting back into the world of Excel, and I'm super-rusty with the past few versions. I haven't done much in years, but I'm enjoying re-learning it!
Thanks in advance for your help.
TL
How can I set up some sort of lookup table or data table to get these sorted properly? From the source data, I will be putting these into a pivot table. At what point, can I get these in the desired order?
Please use "small words" I'm just getting back into the world of Excel, and I'm super-rusty with the past few versions. I haven't done much in years, but I'm enjoying re-learning it!
Thanks in advance for your help.
TL
Last edited: