In Excel spreadsheets, merged regions typically assign the actual value only to the top-left cell, leaving NaN (Not a Number) entries for the remaining spanned area. This structure introduces gaps during data analysis. Leveraging the pandas library resolves these blanks efficiently.

Load the data from the target workbook initially:

import pandas as pd

spreadsheet_data = pd.read_excel('data_workbook.xlsx')

To propagate the merged value across its associated empty cells, apply a forward-fill operation. This replaces the missing entries with the last valid observation:

processed_data = spreadsheet_data.ffill()
print(processed_data)

A complete workflow intergates the workbook ingestion and the interpolation of the blank spans:

import pandas as pd

def load_and_unmerge_excel(file_path):
    raw_data = pd.read_excel(file_path)
    interpolated_data = raw_data.ffill()
    return interpolated_data

final_dataset = load_and_unmerge_excel('data_workbook.xlsx')
print(final_dataset)