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
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