import pandas as pd df = pd.read_excel('D:/Merge/test01.xlsx') df['NAME_NBR'] = df.groupby(['源']).cumcount()+1 #计算第几次重复出现 df = df.pivot(index='源', columns='NAME_NBR', values='目标') df.columns = ['VALUE{}'.format(c) for c in df.columns] df.reset_index(inplace=True) print(df)