Все публикации

0:06:39

Dependent Drop-Downs, Dynamic Array Formula Edition

0:10:44

Using Power Query to turn tabular data into an unstructured report!

0:02:37

MAXIFS(...) in PowerQuery

0:04:56

Power Query - Transform certain rows into columns

0:03:55

Match an id to a name based on most frequent occurrence

0:05:07

Power Query - Determining grade based on points and a rules table

0:06:49

Power Query - Combining multiple sheets from multiple workbooks

0:15:11

Power Query makes yet another awful report usable

0:04:13

Lousy extract format? Never fear, Power Query is here!

0:06:06

Power Query - Multi-header unpivot

0:02:03

Power Query - Expanding a range of seat locations

0:04:34

Power Query - Cleaning up and extracting parts of a list of addresses

0:01:31

Power Query - number of different customers who've ordered a specific part

0:01:11

Power Query - Extract text between space and semicolon

0:03:36

Power Query - extracting parts of a string to separate columns

0:00:48

Power Query fill down and pivot

0:09:38

Power Query - finding overlaps between time intervals

0:01:09

Power Query - splitting one row of data into two

0:03:07

Power Query - generate a table with one column per month

0:00:55

Power Query - parsing JSON data

0:02:18

Power Query: Load and Transform Text File

0:01:40

Power Query: split to rows

0:02:25

Power Query: combine tables

0:05:04

Power Query: sorting and reorganizing list of grades