{"id":5544,"date":"2016-12-10T10:24:13","date_gmt":"2016-12-10T09:24:13","guid":{"rendered":"https:\/\/www.myexcelonline.com\/?p=5544"},"modified":"2024-02-06T16:17:59","modified_gmt":"2024-02-06T15:17:59","slug":"fill-values-using-power-query","status":"publish","type":"post","link":"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/fill-values-using-power-query\/","title":{"rendered":"Fill Down Values Using Power Query"},"content":{"rendered":"

Power Query<\/a> lets you perform a series of steps to transform your Excel data. \u00a0One of the steps it allows you to take is to\u00a0fill data down easily<\/strong>.<\/p>\n

You might be wondering when you might need to fill data down in your table.<\/p>\n

Let’s suppose you have this set of data:<\/p>\n

\"Fill<\/a><\/p>\n

A lot of values are missing in the Sales Quarter column! It would be a lot of effort to input them one by one.<\/p>\n

Let us sort the Sales Month<\/strong><\/em>, then the Sales Quarter<\/strong><\/em> column to get a better understanding:<\/p>\n

\"Fill<\/a><\/p>\n

You can see that we have at least one sales quarter populated for each month<\/strong>.<\/p>\n

The technique here is that the\u00a0Fill Down<\/strong> will copy the value directly above the empty cell and then fill it down the succeeding empty cell.<\/p>\n

You can see from the arrows what will happen once we use\u00a0Fill Down<\/strong> in Power Query<\/a>.<\/p>\n

Now that you know what our game plan is, let us get started!<\/p>\n

 <\/p>\n

\n