Transposing Data

[bolandd]

First off, I am fairly proficient with Excel and VBA.

I would like to take some existing data and transpose it via VBA.

The end result would be:

Duck Donald 01/04/2011 1.25
Duck Donald 01/05/2011 .25
Duck Donald 01/10/2011 .5
Mouse Mickey 01/11/2011 1.75
Mouse Mickey 01/12/2011 1.75
Disney Walt 01/03/2011 1.25
Disney Walt 01/05/2011 .75
Disney Walt 01/10/2011 1.5

Thanks in advance...

 

[bolandd]

still looking for a solution...

 

[Joe4]

First off, I am fairly proficient with Excel and VBA.

Since you say you are fairly proficient in VBA, I'll just try pointing you in the correct direction.

Loop through your date range (two loops, columns and rows).
If there is a non-zero entry in the cell, write the values from columns A and B and the corresponding column header to a new row (probably on a new worksheet). Continue on for the rest of the columns, then the rest of the rows.

Why don't you see how far you can get with it, and post back here if/when you run into specific problems?