The Majesty of DUPLICATE QUERY in Power Query

/in /by

Duplicate Query in Power Query is underused and under-discussed. This video shows one way to use Duplicate Query to save from doing a lot of work over and over again.

This video also shows split column; split column non-digit to digit; a little M-code. There’s great stuff to keep you from having to work so hard to get cooperation from your data.

For an intro to Get & Transform (Power Query) try my Lynda/LinkedIn course:
https://www.linkedin.com/learning/instructors/oz-du-soleil?trk=insiders_28299411_learning
Website: https://ozdusoleil.com

My book: Guerrilla Data Analysis 2nd Edition

My old blog: http://datascopic.net/blog-2-2