There's a lot in this video! When you get this working, you'll be entitled to wear your underwear outside your pants like a true Super Hero!

The challenge:
We'd like random names, but also choose which format we'd like our result in:
- First Name Last Name
- Last Name, First Name
- First Name MI Last Name
- Last Name, First Name MI

I thought about using a custom function but realized it'd be simpler to drill down (pass a parameter).

In this video you see:
- Column by Example
- Excel Tables
- Power Query
- Left Outer Join
- M Code
- Merge Columns
- and EVVYTHANG!

Download the file here:
[ Ссылка ]

For an intro to Get & Transform (Power Query) try my Lynda/LinkedIn course:
[ Ссылка ]


#PassParameter
#DrillDown
#OuterJoin

Website: [ Ссылка ]

My book: Guerrilla Data Analysis 2nd Edition
[ Ссылка ]

My old blog: [ Ссылка ]

свернуть