This site uses different types of cookies, including analytics and functional cookies (its own and from other sites). To change your cookie settings or find out more, click here. If you continue browsing our website, you accept these cookies.
Here's my solution to challenge 7.
Here's my solution!
Here's my solution for this one. Thanks,
#7 done - great to see all the alternative approaches posted on this one.
Challenge completed by separating out the data into 2 streams, one with the headers and the other with the data values. Cross tab both streams and bring back together with a Union
Used text to columns to get Record IDs as regex isn't as strong!
Here is my solution !