You have a data set but it is not structured correctly, and therefore cannot Pivot or filter properly of the information to drill down into information of interest. Additionally, data may be in one column and you want to split/separate that single data into multiple columns e.g. one row and cell contains multiple information in the same cell, like name, telephone, which you want split into multiple cells. Cleaning data for unnecessary characters. Adding subsequent flag column, further adding depth to existing data which wouldn't not of existed initially.
excel data cleansing and restructur
excel data cleansing and restructuring, reformating, conditional formatting, ready for Pivot/Filter