Change data from vertical to horizontal?

Hi, I am very new to excel and im trying to figure out this simple project. We sell T-shirts and we save our inventory in a database. When we get our csv file, this is how it comes out.


A B C D E
1 style sml med lrg xl
2 8220 y y y y
3 8230 y n n y
4 8240 n y y y
5 8250 n n n n
6 8260 y y n y

We need to have it changed to how it looks below.

A B C
1 8220 sml y
2 8220 med y
3 8220 lrg y
4 8220 xl y
5 8230 sml y
6 8230 med n
7 8230 lrg n
8 8230 xl y
9 8240 sml n
10 8240 med y
11 8240 lrg y
12 8240 xl y
13 8250 sml n
14 8250 med n
15 8250 lrg n
16 8250 xl n
17 8260 sml y
18 8260 med y
19 8260 lrg n
20 8260 xl y


Here we are only displaying 5 products, but we have 100's of products that we need to do this to. If there is anyone that can help me figure this out, i would appreciate it so much! Thank you to anyone that puts in effort trying to help us with this project!!! We really got stuck on this one part and we feel handicapped...

Thanks!