Data Filtration and Convert in Required Format

  • Dear Experts,

    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.

  • How about

Participate now!

Don’t have an account yet? Register yourself now and be a part of our community!