Power query or table will handle it! Center
Column two . For larger your data input of common column as in