Complex Data Cleaning

[noushad1ali2000]

Greetings,

I am regular watching your vlog related excel, and now i need your help to clean a complex type of data extracted from my company system which i need to clean and provide them in simple form to create some insight from that.

1st sheet as sample extracted (
i have given two sets of data as sample, whereas in my co file having 25860 rows of data for almost 1185 person

2nd sheets need to be normalized

I have attached sample with dummy data as an attachment

it would be much appreciated if you could help me out

Thanks
Naushad Ali

 

[p45cal]

cross posted without links:

Complex Data cleaning

I am regular watching your vlog related excel, and now i need your help to clean a complex type of data extracted from my company system which i need to clean and provide them in simple form to create some insight from that. 1st sheet as sample extracted ( i have given two sets of data as...

chandoo.org

@noushad1ali2000, for your information, you should always provide links to your cross posts.
This is a requirement, not just a request.
If you have cross posted at other places, please add links to them too.
Why? Have a read of https://excelguru.ca/a-message-to-forum-cross-posters/