Need help in transforming my Data

[Saqibmughal00]

My data has the date, the header and the value all in one column, what would be best way to sort it out.

[Anonymous · Accepted solution]

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.}

[mickey64]

How about ’Transpose’?

I would like to know the title of these rows.

[Saqibmughal00]

the title is higlighted in yellow. and transpose wont work as I have alot of data in columns

[Saqibmughal00]