Hi , I have a excel file with me (Attached: Test Data Qlik) which contains unstructured data, it have following anomalies:
- Have blank rows between data, I want to get rid of those.
- Have a Parent Product in One cell of Column and then Child product line in multiple cells in other column. I want Parent product to be replicated in front of each child product line.
If you see the excel file, the left side is the current state of the data I have and the right one is the desired state. Can someone please help me with guidance on how to profile data in this case?
