by Maya Raviv | Oct 11, 2021 | Power Query
Hi again. This is Maya (you can find me on Linkedin here), with my second post on DataChant: a revision of a previous tutorial. Removing empty rows or columns from tables is a very common challenge of data-cleaning. The tutorial in mention, which happens to be one of...
by Gil Raviv | Apr 9, 2018 | Book, Popular
The draft of my book is almost ready (I even have few Excel formulas that are showing me, that I have already wrote 93% of the books, and a total of 359 draft pages so far). This weekend, after finishing 44 pages on M, I wanted to share with you, in this post, a...
by Gil Raviv | Feb 14, 2018 | Uncategorized
How many times did you have to work with tables that had headers like these? Client_ID, Transaction_ID, Product_Name, My_DBA_is_in_Love_with_Underscored_Headers No need to manually rename the column names any more, if you work with Excel Get Data / Power Query, or...
by Gil Raviv | Dec 9, 2016 | Uncategorized
Follow @gilra In today’s tutorial, we will solve a very common challenge in Excel. You start with an Excel table and you wish to condense it by removing all the columns and/or rows that are entirely empty, and usually, you don’t have prior knowledge of...
by Gil Raviv | Jun 2, 2016 | Popular
Following a reader’s request, today we will unleash the power of List.Accumulate. The official documentation on List.Accumulate here was very confusing for me: List.Accumulate(list as list, seed as any, accumulator as function) as any Argument Description list...
