How to Re-arrange serial no. with size in Excel ?

[nagesh12]

Dear Chandoo,

I read all your articles, it's very interesting & inspiring to solve
any problem in excel.

I'm uploading some products in my website, I'm sending you attached document.

My Problem : In excel , I've 100 to 1000 of products with different size.
I want to re-arrange serial no. with size,

ex: serial no.1, size = 36,38,40, serial no.2 = s,m, l

I want to re-arrange it to

serial no.1, size =36
serial no.1, size = 38
serial no. 1, size =40

serial no. 2=s
serial no.2=m
serial no.2=l

I've shown multiple examples in excel.

Please solve my issue, i'm requesting you sir.

Thanks for your help in advance.

Your's Sincerely,
Nagesh

 

[John Jairo V]

Hi @nagesh12

What is the answer with info like B15?

Bra Size : 30,32,34,36 & Brief Size : S,M,L,XL

Same question B19 to B24. Blessings!

 

[nagesh12]

Hello Sir,

The answer is :

Bra Size : 30 & Brief Size : S
Bra Size : 30 & Brief Size : M
Bra Size : 30 & Brief Size : L
Bra Size : 30 & Brief Size : XL
Bra Size : 30 & Brief Size : XXL

Bra Size : 32 & Brief Size : S
Bra Size : 32 & Brief Size : M
Bra Size : 32 & Brief Size : L
Bra Size : 32 & Brief Size : XL
Bra Size : 32 & Brief Size : XXL

Bra Size : 34 & Brief Size : S
Bra Size : 34 & Brief Size : M
Bra Size : 34 & Brief Size : L
Bra Size : 34 & Brief Size : XL
Bra Size : 34 & Brief Size : XXL

Bra Size : 36 & Brief Size : S
Bra Size : 36 & Brief Size : M
Bra Size : 36 & Brief Size : L
Bra Size : 36 & Brief Size : XL
Bra Size : 36 & Brief Size : XXL

Above answer is same for B19 to B24.

Thanks for your Kind Response.
Have a nice day..
Nagesh