Fill The Blank

The request was to create analysis of a thousand data that's exported directly from a web/program.

This kind of data use to be named as Raw Data.

Data Reporting,. The process will be able to start when the data has been tidied.

Tidy mean that all row or column has the complete description or identification of each information in the cell, like a database should be.

So there's no header for identification.

Example as below;

To process this data, then we need to complete the detail of each blank cell with the category or the header mention.

Then we will use IF.

Logic formula to complete will be;

The logic was; if the header cell is not blank, then we will call its description to fill in the cell. But if its blank, we will call the description above.

=IF(A3<>0,A3,B2)

The first started cell should be copy paste first, then start with the formula and drag it down.

Then the result will be as below;

Then you now can start analysis the data for reporting.