Forum Discussion
Manipulating Data - Fill Down
Hi All, first time posting here, so here goes... I have some data from an excel sheet that looks like this: 2012 UK + IRELAND Jan Feb Mar Apr May ...
Have you tried "Fill Down" when you Edit Queries - e.g. see this post: https://www.excelcampus.com/library/fill-down-blank-null-cells-power-query/
And it might help in the long run if you filter out the TOTAL rows for a cleaner data model.