This is because you don't have any sub id information on import&export sales sheet. So it duplicates normally. I think you are gonna need to add Sub ID data to sheet1. Or -the better way- is to gather measures in one sheet and add sub ID or ID to those measures. It depends on how do you want to analyze data. As i said, if you want to analyze it based on sub id, then the values must be cluttered to sub ids.