Forum Discussion
Thomas_MedOne
Helper III
Helper IIICopying 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...
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
Super User
Super UserJust right click on the column call ID, and then select fill down.
Thomas_MedOneHelper III
Helper IIIThis 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.