Programming
import pandas as pd # Load the Excel file into a DataFrame df = pd.read_excel("your_file.xlsx") # Split the header into multiple columns based on ';' header_split = df.columns[0].split(';') # Create a new DataFrame to store the split values split_values = pd.DataFrame(columns=header_split) # Iterate through each row and split the values after ';' for index, row in df.iterrows(): values = row[df.columns[0]].split(';') # Pad the split values if there are fewer values than columns if len(values) < len(header_split): values += [''] * (len(header_split) - len(values)) split_values.loc[index] = values # Concatenate the split_values DataFrame with the original DataFrame df = pd.concat([df, split_values], axis=1) # Drop the original column containing the combined header and values df.drop(columns=[df.columns[0]], inplace=True) # Display the DataFrame print(df)