各位大侠,我的原始数据如下所示:
X Y
1 1
2 2
3 3
4 4
5 5
···
···
99 99
由于Y总共有99个值,所以,我想生成Y01到Y99,然后,只有当Y的取值,与Y0n中n的值相同的行列交点处的值才能取1,否则,只能取0。也就是要形成这样的表格
X Y H01 H02 H03 H04········
1 1 1 0 0 0 ·······
2 2 0 1 0 0 ········
3 3 0 0 1 0········
4 4 0 0 0 1 ·········
····································
····················································
感觉需要用到很复杂的宏技术,所以,跪求高手指点,跪求指点。谢谢。谢谢。跪求。跪求。。。