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 - 22 Jan 2007 00:25 GMT
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
> 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?
[quoted text clipped - 18 lines]
>
> Thanks!

Signature
Debra Dalgleish
Contextures
http://www.contextures.com/tiptech.html