Forum Discussion
Thomas_MedOne
1 year agoHelper III
Copying column value until value changes then new value
I have this system that outputs log files but it does so in an infuriating way. The data pretty much looks like this (with more columns) Call ID From To Result Date/Time 11111222 614-1...
- Anonymous1 year ago
Why that just sounds like you need to use Table.FillDown on the GUI. if they are not actually null values, replace that value with nulls and then fill down.
--Nate
Omid_Motamedise
1 year agoSuper User
Just right click on the column call ID, and then select fill down.
Thomas_MedOne
1 year agoHelper III
This was the solution but Watkinnc was just a bit closer because I tried this and it didn't work. I had to convert them to nulls first.