Step by step guidance for the solution
1. For Combine data use Union tool
2. Then for remove duplicate customers use Unique tool
3. To spit user details use text to columns tools and for splitting data use "|" as delimiter
4. Join the combine data and Split data on the basis of customer ID
uploaded