Complex Data cleaning

[noushad1ali2000]

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

 

[vletm]

noushad1ali2000​

How do You ... extract ... data to rawData-sheet?
Could You send a sample of real rawdata?

 

[pecoflyer]

Cross post https://forums.excelguru.ca/threads/complex-data-cleaning.11961/#post-49509

 

[vletm]

noushad1ali2000​

Please, You should reread Forum Rules

Site Rules - New Users - Please Read

Hi all, Welcome to the Chandoo.org Forums. Posting Rules & Etiquette The Chandoo.org Forums is a collaborative and happy place to learn and expand your Excel knowledge. The Chandoo.org Forums consist of several Sub-Forums based on the type of question/area of Excel you are interested in...

chandoo.org

to get replies.