Run Code  | API  | Code Wall  | Misc  | Feedback  | Login  | Theme  | Privacy  | Patreon 

Transpose group per sequence

Language: Layout:
View schema
Execution time: 0,03 sec, rows selected: 11, rows affected: 12, absolute service time: 0,19 sec 
edit mode |  history  | discussion
   fid FamilyMember FullName1 seq1 Related1 FullName2 seq2 Related2 FullName3 seq3 Related3 FullName4 seq4 Related4 FullName5 seq5 Related5
1 1 1 FSDFE 1 Household 0 0 0 0
2 2 1 0 0 0 0 0
3 2 2 BVCB 2 Household JHGTYJ 3 Spouse 0 0 0
4 2 3 0 0 ZC 4 Household ER 5 Spouse VBCV 6 Daughter
5 5 5 MJGG 8 Household ZDF 9 Spouse GFDR 10 Mother JKTY 11 Daughter OUI 12 Son