Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
I would appreciate your help please.
'Full Name', 'Notify Date' and 'Response Date' are currently in rows as shown in 'Current'. I want to transfer those specific rows into column titles and display data beneath as shown in 'Preferred outcome'
Solved! Go to Solution.
Ignore this, I found a solution by adding delimeters and adding columns extracting data by delimeters and seperating columns. Thank you 🙂
Ignore this, I found a solution by adding delimeters and adding columns extracting data by delimeters and seperating columns. Thank you 🙂
Hi, it is possible to transform it, but I would strongly advise you to adjust rather the entry format because there is a good chance, that in future with more data there will be an error.
Data is csv download, so I managed to find a solution using delimeters and add columns. Thank you 🙂