Put together data

%3CLINGO-SUB%20id%3D%22lingo-sub-2231134%22%20slang%3D%22en-US%22%3EPut%20together%20data%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2231134%22%20slang%3D%22en-US%22%3EGood%20evening%20everyone%2C%20I%E2%80%99m%20looking%20for%20some%20help%20because%20I%E2%80%99m%20having%20issues%20with%20excel%2C%20I%20would%20like%20to%20make%20a%20link%20between%20a%20person%20(the%20main%20one)%20with%20others%20(%20family)%20and%20keep%20everything%20divided%20in%20different%20cells...%3CBR%20%2F%3Eso%20if%20I%20decide%20to%20filter%20Mr.%20X%20I%E2%80%99ll%20be%20able%20to%20see%20Mr.%20X%20infos%20plus%20his%20families...%20and%20if%20I%20have%20to%20sort%20by%20for%20example%20color%20of%20hair%2C%20I%E2%80%99ll%20be%20able%20to%20do%20that%2C%20followed%20with%20family%20infos%20as%20well..%3CBR%20%2F%3E%3CBR%20%2F%3EThank%20you%20very%20much%20for%20your%20help%2C%20I%E2%80%99ll%20really%20appreciate%20it%20if%20you%20can%20save%20me%20%3Agrinning_face_with_sweat%3A%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2231134%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
Occasional Visitor
Good evening everyone, I’m looking for some help because I’m having issues with excel, I would like to make a link between a person (the main one) with others ( family) and keep everything divided in different cells...
so if I decide to filter Mr. X I’ll be able to see Mr. X infos plus his families... and if I have to sort by for example color of hair, I’ll be able to do that, followed with family infos as well..

Thank you very much for your help, I’ll really appreciate it if you can save me
1 Reply

@MattDN 

Looks like that's job for lookup functions (XLOOKUP, etc), but it very depends on how your data is organised. Perhaps you may provide small sample file with removed sensitive information.