troubleshooting Question

Excel transpose

Avatar of Philippe Renaud
Philippe RenaudFlag for Canada asked on
Microsoft OfficeMicrosoft ExcelMicrosoft ApplicationsSpreadsheets
4 Comments2 Solutions166 ViewsLast Modified:
hi EE,

I have thos columns in excel :

Style      Model Code      Description      Scale Description      Sizes      QTY
A123         1123                TEST A                  INCHES               44           7
A123         1123                TEST A                  INCHES               46           3
A123         1123                TEST A                  INCHES               50           1
A123         1123                TEST A                  INCHES               52           17

B777         3411                TEST B                  REG                     R32           2
B777         3411                TEST B                  REG                     R34           37

is there a way in excel to transpose this for the sizes to be across left to right instead of up to down ?  like this :

A123         1123                TEST A                  INCHES                           44              46              50                52
                                                                                                               7                3               1                  17

B777         3411                TEST B                  REG                                R32            R34
                                                                                                              2                 37

let me know.. .?
Matt Nicholas
Sales Planning Analyst APAC

Our community of experts have been thoroughly vetted for their expertise and industry experience.

Join our community to see this answer!
Unlock 2 Answers and 4 Comments.
Start Free Trial
Learn from the best

Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.

Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 2 Answers and 4 Comments.
Try for 7 days

”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.

-Mike Kapnisakis, Warner Bros