id,cat1,cat2,cat3
---
 0,val1,val2,val3
 1,val4,val5,val6

id,cat,val
---
0,cat1,val1
0,cat2,val2
0,cat3,val3
1,cat1,val4
1,cat2,val5
1,cat3,val6