Drastically shorten your training time with WalkMe's advanced online training solution that Guides your trainees to action. Forget about retraining and skyrocket knowledge retention rates.
Course Of The Month
5 days, 4 hours left to enrollBecome a Premium Member and unlock a new, free course in leading technologies each month.
Solved
Excel - Sort multiple columns based on single column
Posted on 2012-12-20
Hi everyone,
Hopefully I can explain this correctly...
I am creating a spreadsheet to keep track of inventory. I would like to take the SKU #, model #, size, and style (wide, medium, etc.), which are already in a row...
SKU MODEL SIZE STYLE
829024209851 26063 14 W
829024209852 26063 12 W
829024209853 26063 19 M
...and copy them into another worksheet on the same spreadsheet in a different format.
MODEL STYLE 12 13 14 15 16 17 18 19
26063 W 1 1
26063 M 1
...What this would do is allow there to be a quick way of seeing how many of each style there are per size. Each row is a different model (of course, each model has multiple styles, or widths, such as medium, wide, extra wide, etc.).
Is this possible???
Hopefully I can explain this correctly...
I am creating a spreadsheet to keep track of inventory. I would like to take the SKU #, model #, size, and style (wide, medium, etc.), which are already in a row...
SKU MODEL SIZE STYLE
829024209851 26063 14 W
829024209852 26063 12 W
829024209853 26063 19 M
...and copy them into another worksheet on the same spreadsheet in a different format.
MODEL STYLE 12 13 14 15 16 17 18 19
26063 W 1 1
26063 M 1
...What this would do is allow there to be a quick way of seeing how many of each style there are per size. Each row is a different model (of course, each model has multiple styles, or widths, such as medium, wide, extra wide, etc.).
Is this possible???
[X]
Welcome to Experts Exchange
Add your voice to the tech community where 5M+ people just like you are talking about what matters.
- Help others & share knowledge
- Earn cash & points
- Learn & ask questions
-
3
2
2
7 Comments
I suggest to use Pivot table.
Model and Style will be in Row header, Size in column header and the Data could be Count of size.
Cheers,
Kris
Model and Style will be in Row header, Size in column header and the Data could be Count of size.
Cheers,
Kris
Attached sample...
sample.xls
sample.xls
AWESOME!....I think the last part then is getting the formula to have the single row of 26063 W, and the single row of 26063 M...from the rows below...
SKU MODEL SIZE STYLE
829024209851 26063 14 W
829024209852 26063 12 W
829024209853 26063 19 M
I'm really scuffling with this part...
SKU MODEL SIZE STYLE
829024209851 26063 14 W
829024209852 26063 12 W
829024209853 26063 19 M
I'm really scuffling with this part...
Hi,
Attached a pivot table example.
If you have new data rows - go to pivot table menu (you find it above the ribbon, when the pivot table is active) and change the data source.
If you change the data in the table, right click on the table, then refresh.
(You can see it on sheet Data and Pivot.)
OR
You can define your data as Table and build the pivot table on this table. This way it will be dynamic, when you add new data to the Table (write in the rows below) you will see the Table is expanding. You only need to refresh your Pivot table, it will immediately capture the new data rows.
(You can see this example on sheet Data as Tabel and Dynamic Pivot.)
Cheers,
Kris
Pivot-table-example.xlsx
Attached a pivot table example.
If you have new data rows - go to pivot table menu (you find it above the ribbon, when the pivot table is active) and change the data source.
If you change the data in the table, right click on the table, then refresh.
(You can see it on sheet Data and Pivot.)
OR
You can define your data as Table and build the pivot table on this table. This way it will be dynamic, when you add new data to the Table (write in the rows below) you will see the Table is expanding. You only need to refresh your Pivot table, it will immediately capture the new data rows.
(You can see this example on sheet Data as Tabel and Dynamic Pivot.)
Cheers,
Kris
Pivot-table-example.xlsx
Featured Post
Make Your Microsoft Dynamics Investment Count & Drastically Decrease Training Time by Providing Intuitive Step-By-Step WalkThru Tutorials.
Question has a verified solution.
If you are experiencing a similar issue, please ask a related question
Microsoft Office Picture Manager is not included in Office 2013. This comes as a shock to users upgrading from earlier versions of Office, such as 2007 and 2010, where Picture Manager was included as a standard application. This article explains how…
Do you use a spreadsheet like Microsoft's Excel? Have you ever wanted to link out to a non excel file on your computer or network drive? This is the way I found to do it!
Learn how to make your own table of contents in Microsoft Word using paragraph styles and the automatic table of contents tool. We'll be using the paragraph styles in Word’s Home toolbar to help you create a table of contents.
Type out your initial …
Polish reports in Access so they look terrific. Take yourself to another level. Equations, Back Color, Alternate Back Color. Write easy VBA Code. Tighten space to use less pages. Launch report from a menu, considering criteria only when it is filled…
Suggested Courses
Course of the Month5 days, 4 hours left to enroll
688 members asked questions and received personalized solutions in the past 7 days.
Join the community of 500,000 technology professionals and ask your questions.