I’m going to show you how to create a delimited list using the Power Query. I came across this question in the Enterprise DNA Forum where a member wanted to create a list of products that each distinct customer bought. This can be easily done via the Power Query. You may watch the full video
I’m going to show you how to extract records from merged delimited data within multiple columns. This turns your data into a format that’s more suitable for analysis. There are a number of ways to do this. But for this tutorial, I’m going to focus on a solution suggested by Ankit, who’s part of our
