Starting a CrossTable

[#1]

Hi not sure where to start from converting Table A into Table B, I know there is a cross table function, but whats the best way to use it. The real Table A will have 50,000 + rows and the Number of Months can be up to 240.

Table A
Opp No	Start Year-Month	Hours Per Month	No of Months
A	1501	10	3
B	1502	15	4
C	1503	12	3

Table B
Year Month	Opp No	Hours
1501	A	10
1502	A	10
1503	A	10
1502	B	15
1503	B	15
1504	B	15
1505	B	15
1503	C	12
1504	C	12
1505	C	12

[MarcoWedel]

You're welcome

regards

Marco