Need help in transforming my Data

Hi Saqibmughal00 

 

My solution is as follows, you can try it out.

 

1. Delete “SOW”, “MODULE” columns. 
2. Select “Workspack” column and then transpose.  

    

3. Delete the second column.  

    

4. Use first row as headers.  

    

5. Select “Column1”, ”WORKSPACK” columns and then select “Unpivot other columns” under “Unpivot Columns”.  

    

6. Select “Column1” column and then split the column by delimiter “_”.  

    

7. Delete “Column1.2” column.  

    

    

8. Change “Column1.1” column data type with locale, Data Type select “Date” and Locale select “English(United Kingdom)”.  

    

9. Rename the headers.  

    

10. Pivot Column by “Value” column.  

     

11. Here‘s my final result.  

     

 

I hope this solution meets your requirements.

 

 

^{Best Regards,}

^{Jarvis Tang}

^{If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.}