Forum Discussion
Solved
Replace Null with value above in Location column
I am importing a table which has nulls in the location column , is there a way to add the above row value to a null value
original
Location Depart Arrive Depart_1 Return No. Frequency
| Bethel | 03:45:00 | 05:15:00 | 06:15:00 | 07:45:00 | 703 | Tues - Sat |
| Kotzebue | 20:00:00 | 23:40:00 | 00:40:00 | 02:40:00 | 741 | Tues & Thurs |
| null | 11:00:00 | 14:40:00 | 15:40:00 | 17:40:00 | 742 | Sat |
| Nome | 20:00:00 | 21:55:00 | 22:55:00 | 02:40:00 | 741 | Tues & Thurs |
| null | 11:00:00 | 12:55:00 | 13:55:00 | 17:40:00 | 742 | Sat |
| St. Mary's | 10:00:00 | 11:45:00 | 13:00:00 | 16:45:00 | 744 | Tues, Thurs & Sat |
fixed
Location Depart Arrive Depart_1 Return No. Frequency
| Bethel | 03:45:00 | 05:15:00 | 06:15:00 | 07:45:00 | 703 | Tues - Sat |
| Kotzebue | 20:00:00 | 23:40:00 | 00:40:00 | 02:40:00 | 741 | Tues & Thurs |
| Kotzebue | 11:00:00 | 14:40:00 | 15:40:00 | 17:40:00 | 742 | Sat |
| Nome | 20:00:00 | 21:55:00 | 22:55:00 | 02:40:00 | 741 | Tues & Thurs |
| Nome | 11:00:00 | 12:55:00 | 13:55:00 | 17:40:00 | 742 | Sat |
| St. Mary's | 10:00:00 | 11:45:00 | 13:00:00 | 16:45:00 | 744 | Tues, Thurs & Sat |
Just found the solution , transform data , fill down
1 Reply
Just found the solution , transform data , fill down