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!

The easiest way is going to be with a macro. Here's the code:

Please Login or Register  to view this content.

You'll need to insert this permanently into a workbook.

How to use the macro:

1. Open up your workbook
2. Get into VB Editor (Press Alt+F11)
3. Insert a new module (Insert > Module)
4. Copy and Paste in your code (given above)
5. Get out of VBA (Press Alt+Q)
6. Save your sheet

The macro is installed and ready to use.

First, bring up your CSV file so that it is onscreen, then press Alt-F8 and select this macro from the list.

It will create a worksheet called NewTable and put the data in the format you want. You can move the resulting sheet elsewhere or to another book, up to you.