Your expertise are required i have 1000+ data as i attached below for example.
In first sheet which name is "Data" contains raw data where "X" mean is incomplete.
First i change the "X" with Column header for my working manually (as i did in 1st Example Sheet).
Then filter the data and copy paste it (as i did in 2nd Example sheet)
I am doing this activity since couple of months which takes whole day to complete it.
I am looking for VBA for this task if you guys could help i will be really appreciate it.
looking forward to your response.