Excel table issue

Hi guys,

Is there any function from Excel can change table like below.

Product ID      Store Qty            
11                      A         1            
22                      B         2            
33                      C         3            
44                      D         4            

Change      to:
Product ID      A      B      C      D
11                     1                  
22                            2            
33                                   3      
44                                         4
Thanks a lot.
Who is Participating?
Rory ArchibaldCommented:
You could use a pivot table. Put ProductID in the row field area, Store in the column area and Qty in the data area.
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.