Reverse-engineering an Excel pivot table-type dataset

[Guest]

I have a dataset in pivot/crosstab format. Can anybody think of an easy way
to take this dataset and turn it into a database-ready table?

That is to say, data is in the format:

Name Jan Feb Mar
**** **** **** ****
John 2 4 6
Mary 3 1 8

and I want to wind up with

Name Month Qty
**** ***** ***
John Jan 2
John Feb 4
John Mar 6
Mary Jan 3
Mary Feb 1
Mary Mar 8

Thanks!

 

[Debra Dalgleish]

To reorganize the data, you may be able to use the "unpivot' technique
described by John Walkenbach:

http://j-walk.com/ss/excel/usertips/tip068.htm