split_names = df['Name'].str.split(', ', expand=True).stack()
split_names.name = 'Name'
split_names.index = split_names.index.get_level_values(0)
df.drop('Name', axis=1, inplace=True)
DataFrame transformation in Python Pandas