Forum Discussion
Solved
Unstructured data transform question
Hi guys, A piece of software I use exports its .csv files in a very... bad way. See below Name DescriptionA ValueA DescriptionB ValueB DescriptionC ValueC Car1 Door 2 Window 4 T...
Hi davidmeblack
See the attached file here. Hope it will help... See the Merged Table in Query Editor
Hi,
You may refer to my Blog article - Restructure the layout of datasets. Refer to Case 1.
Hope this heps.
Hi davidmeblack
See the attached file here. Hope it will help... See the Merged Table in Query Editor
Here are the steps
1) Unpivot all columns other than Car
2) Filter Rows that CONTAIN word "Description"
3) Add an Index Column
Now Create a Duplicate Query
1) Filter rows that CONTAIN word "Value"....
Now we can merge these 2 Queries