Forum Discussion
Solved
POWER QUERY - Fill lines
I need the value 4.23~ to fill a column in front of the other data in the PV column. I tried using FillUp and other techniques but they all fail.
Below is the final table:Just reinforcing that this is a model of several imported spreadsheets, the value "MK REALIZADO" will not always be in line 3.Sorry, but I couldn't find another question like this.Thanks,
I came up with a solution, turned the above data to null and the padding worked.
3 Replies
I came up with a solution, turned the above data to null and the padding worked.
Hello Luan90 ,
If you mean you want to replace the "MK REALIZADO" with 4,23 then you could use replace in power query.
If I answered your question, please mark my post as solution, Appreciate your Kudos👍
Thanks, but that's not it. Sorry if I wasn't clear. I need to import 100 excel sheets, the value "4.23" is not always the same, it varies. It is always in the same column, but not in the same row. The final table I need is:
