I have a large spreadsheet of data with a mix of merged cells and individual cells (e.g. column A contains large merged cells (A2:A4999) indicating a primary location, column B contains smaller merged cells (B2:B299) indicating a sub-location, column C contains individual cells (C2) indicating equipment in that specific location). In order to make best use of the data (either sorting, filtering, or using pivots) I would like to un-merge each merged cell and distribute the text to the resulting split cells (e.g. each un-merged cell in column A would be filled with the primary location, etc.).