format in excel

[Fashion_Tech]

Hi Everyone,
I have a sizing spread sheet that looks like this...

style fabric S M L
Jeff cotton 1 1 1

and I would like to rota it to look this this...

style fabric Size qty
Jeff cotton S 1
Jeff cotton M 1
Jeff cotton L 1


is there a way to pivot it in excel.

Thanks so much!!

 

[Gerald Higgins]

Hi, welcome to the board.

Do you only need to do this once ?

Does every entry have exactly the same 3 sizes ?

If yes to both, you can do this quite quickly with cut and paste.