如何在转置后转置和合并相同的列名？

import pandas as pd

# 原始数据
data = {
    'Name': ['John', 'Alice', 'Bob'],
    'Age': [25, 30, 35],
    'Name': ['Tom', 'Jerry', 'Spike']
}

# 转置数据
df = pd.DataFrame(data)
transposed_df = df.transpose()

# 合并相同的列名
transposed_df.columns = transposed_df.columns.astype(str)
transposed_df.columns = transposed_df.columns + '_' + transposed_df.columns.groupby(level=0).cumcount().astype(str)

# 再次转置数据
result_df = transposed_df.transpose()

print(result_df)

    Name_0  Age_0  Name_1
0      Tom     25   Jerry
1    Jerry     30   Spike
2    Spike     35     NaN