Dear forum,

Iīve been working with power query for some weeks now, but I am struggling with a problem mentioned below.

Below is an excerpt from a csv-file that I import with power query. The columnīs format is text, but it also contains strings that consists only of numbers (i.e. 08800,10000,11200,...). I want to add another column that adds these strings to the different rows. As soon as there appears the next row with numbers, I want that to be added. The additional rows between those
"number-cells" vary from month to month.

I tried some kind of if... then... clause, but I was only able to identify the cells with solo numbers... any hints? (If you have a better solution than "if... then...", of course I would be glad if you share it with me).

Kind regards

Click image for larger version. 

Name:	csv.JPG 
Views:	26 
Size:	21.4 KB 
ID:	9363