hohlick

// fnMassReplace
(
    Source as table, // table to make replacements in
    ToReplace as text, // name of the column for replacements
    ReplaceWhat as list, // list (or column reference) with "what to replace" values
    ReplaceWith as list // list (or column reference) with "replace with" values
) as table =>

let
    CurrentColumns = List.Buffer(Table.ColumnNames(Source)),

idpaterson

Shop Your Way Sweeps Keyboard Shortcuts

Mike-Honey

// Based on Chris Webb's blog post - http://blog.crossjoin.co.uk/2014/05/21/expanding-all-columns-in-a-table-in-power-query/

let
    //Define function taking two parameters - a table and an optional column number 
    Source = (TableToExpand as table, optional ColumnNumber as number) =>
    let
     //If the column number is missing, make it 0
     ActualColumnNumber = if (ColumnNumber=null) then 0 else ColumnNumber,
     //Find the column name relating to the column number
     ColumnName = Table.ColumnNames(TableToExpand){ActualColumnNumber},

codereviews.cs

using Microsoft.TeamFoundation.Client;
using Microsoft.TeamFoundation.Framework.Client;
using Microsoft.TeamFoundation.Framework.Common;
using Microsoft.TeamFoundation.Framework.Server;
using Microsoft.TeamFoundation.WorkItemTracking.Client;
using System;
using System.Collections.Generic;
using System.IO;
using System.Linq;
using System.Text;