Forum Discussion
powerbricco
Advocate I
Advocate IPQ Transformation
Dear All, I have the following table in PowerQuery: Date Value 15/01/2025 null 14/01/2025 null 13/01/2025 null 12/01/2025 null 11/01/2025 null 10/01/2025 null 09/01/2...
I am not a AI response.
Please try this method which i have tested ...
Reference yourdata to create a new table called "dates"
Remove any rows from "dates" that have nullsThen add a index column
Then do the same kind of thingsto create a "values" tables
So you now have 2 tables
Merge the tables using the index to create another table
Expand the table
Congratultaions ... you have your answer
Merge the tables
speedramps
Super User
Super UserAre you just repling with AI generated answers?
You seem to copy and paste answer to previous similare question which do not work for the current question being asked. 😀😀😀