Here to complete this practice work i have used some tools like
unique tool: to remove the duplicates
join tool: to join the data from different files
union tool: to combine the data
text to column tool: the text is converted into the columns' based on the user requirement