FFF: Powery Query (Get and Transform) - Shifting a column up by a single cell
Excel's PowerQuery (Get & Transform) forces the user to think in terms of full column, full rows, full datasets. This creates a problem:
What if you need to shift a column up by just 1 cell? That's easy in native Excel. In PowerQuery this takes several steps.
In this example, artists aren't matched with the right songs. To get them matched properly in PowerQuery, I show:
Index Column
Modulo
Conditional Columns
Fill Up
Check it out!
Download the sample workbook:
http://datascopic.net/FFF-Modulo
My book: Guerrilla Data Analysis 2nd Edition
http://www.amazon.com/Guerrilla-Analy...
My blog: http://datascopic.net/blog2-2