i have data in the form of
Parent key KEY indvidual_number_ in_ roaster completed education mother line number in roaster

PARENT_KEY KEY_ A1_1 education_completed A10_1
uuid:003d89e0-4eb3-402e-ab13-75e0a6224e6c uuid:003d89e0-4eb3-402e-ab13-75e0a6224e6c-1 1 higher .
uuid:003d89e0-4eb3-402e-ab13-75e0a6224e6c uuid:003d89e0-4eb3-402e-ab13-75e0a6224e6c-2 2 secondary .
uuid:003d89e0-4eb3-402e-ab13-75e0a6224e6c uuid:003d89e0-4eb3-402e-ab13-75e0a6224e6c-3 3 higher 2
uuid:003d89e0-4eb3-402e-ab13-75e0a6224e6c uuid:003d89e0-4eb3-402e-ab13-75e0a6224e6c-4 4 higher 2
uuid:003d89e0-4eb3-402e-ab13-75e0a6224e6c uuid:003d89e0-4eb3-402e-ab13-75e0a6224e6c-5 5 secondary 2
uuid:003d89e0-4eb3-402e-ab13-75e0a6224e6c uuid:003d89e0-4eb3-402e-ab13-75e0a6224e6c-6 6 primary 2
uuid:003d89e0-4eb3-402e-ab13-75e0a6224e6c uuid:003d89e0-4eb3-402e-ab13-75e0a6224e6c-7 7 none/pre-shool 2
uuid:003d89e0-4eb3-402e-ab13-75e0a6224e6c uuid:003d89e0-4eb3-402e-ab13-75e0a6224e6c-8 8 none/pre-shool 2
uuid:004b8834-2c03-4a1e-8fc5-6bf2a3379b2b uuid:004b8834-2c03-4a1e-8fc5-6bf2a3379b2b-1 1 primary .
uuid:004b8834-2c03-4a1e-8fc5-6bf2a3379b2b uuid:004b8834-2c03-4a1e-8fc5-6bf2a3379b2b-2 2 none/pre-shool .
uuid:004b8834-2c03-4a1e-8fc5-6bf2a3379b2b uuid:004b8834-2c03-4a1e-8fc5-6bf2a3379b2b-3 3 none/pre-shool 2
uuid:004b8834-2c03-4a1e-8fc5-6bf2a3379b2b uuid:004b8834-2c03-4a1e-8fc5-6bf2a3379b2b-4 4 primary .
uuid:004b8834-2c03-4a1e-8fc5-6bf2a3379b2b uuid:004b8834-2c03-4a1e-8fc5-6bf2a3379b2b-5 5 none/pre-shool 4
uuid:004b8834-2c03-4a1e-8fc5-6bf2a3379b2b uuid:004b8834-2c03-4a1e-8fc5-6bf2a3379b2b-6 6 none/pre-shool 4
uuid:004b8834-2c03-4a1e-8fc5-6bf2a3379b2b uuid:004b8834-2c03-4a1e-8fc5-6bf2a3379b2b-7 7 none/pre-shool 4
uuid:004b8834-2c03-4a1e-8fc5-6bf2a3379b2b uuid:004b8834-2c03-4a1e-8fc5-6bf2a3379b2b-8 8 primary 2

here A10_1 present the line number on which real mother of an individual lies and dot values for those whose mother is not present in roaster. i want to create mother education variable.