Analyze Survey Responses with Power Query

[@fiorellaguerra3814]

Excellent explanation! I'd been struggling with this for about half a day until I found this video :) Thanks!

[@DougHExcel]

Glad it helped!

[@regenwealth]

Absolutely fantastic tutorial!

[@DougHExcel]

Thanks for the kind words!

[@Dogfac3d]

Very insightful! Thanks

[@DougHExcel]

Glad you enjoyed it!

[@regenwealth]

I noticed that the final sliceable table has duplicate sentence records even when LookupWords and ConnectedWords are the same (eg: "room" for both). Is there a way to create a unique set of sentences?

[@regenwealth]

For example: "X" combination of LookupWords and ConnectedWords produces "n" number of unique records

[@nostonethrown56]

I had some issues on the aggregation part. Lol got stuck on some errors messages 😭

[@DougHExcel]

Hi Blue Moose Orchestra, thanks for the comment!