I have data in sheet name Data.
I want to transpose the same data in sheet name Formatted.
But before that one tuff task is from sheet name data, We need to check column E. In column E , need to check unique relations, Columns to be created in Sheet formatted from Column D onwards. for Each relation three column to be inserted, for example for relation "Self", Three column to be created i.e. Self Name, Self Date of Birth, Self Gender. like for for Relation spouse , three column to be created i.e. Spouse Name, Spouse Date of Birth, Spouse Gender.
Also need to check maximum number of child against each employee code. For E.g against employee code 10000522, there are three child i.e child1, child2 and child3, hence for child 9 columns to be created as below
Child 1 Name Child 1 Date of Birth Child1 Gender Child 2 Name Child 2 Date of Birth Child2 Gender Child 3 Name Child 3 Date of Birth Child3 Gender
After that We have to copy and past date in respective column.
For example,
Bookmarks