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.
I achieved this by transposing as usual, with topic and Subtopic as keys, then using the TextToColumns to split on the ":", followed by a REGEX_Replace to clean up the columns. Afterwards, I used the CrossTab Tool, grouping by Topic, Subtopic and Name1 (which is the date in this case), with Name2 as the new column headers, and Value as the values. Name1 and Name2 are the first and second columns created by the TextToColumns Tool.
Let me know if you have any other questions about this workflow,