Contents tagged with M
-
Power Query Pivot Swap
I recently was given a CSV file that listed users and the groups they belonged to, from an Active Directory dump.
-
Power Query to Promote Headers and removing Special Characters
I had an Excel spreadsheet that had "nicely" formatted column headers that made the text appear on separate lines (ie. the text included Alt-Enter linefeeds). I wanted to use it as a source for Power Query (and PowerBI), but remove the linefeeds in the names before promoting them to the column header.