Having run a query against a large table, I end up with some sparcely populated columns, for example :-
ID Folder Name
-- ------ ----
1 F1 aaa
2 bbb
3 ccc
4 F2 ddd
5 eee
6 F3 fff
Where the Folder cell is empty, I wish to 'carry forward' to that cell the previous valid Folder entry, i.e. bbb & ccc will have the value F1, whilst eee will have the value F2.
Can someone possibly tell me how to achieve that, either to be actioned whenever the query is processed or as a one-off update of the original table.
ID Folder Name
-- ------ ----
1 F1 aaa
2 bbb
3 ccc
4 F2 ddd
5 eee
6 F3 fff
Where the Folder cell is empty, I wish to 'carry forward' to that cell the previous valid Folder entry, i.e. bbb & ccc will have the value F1, whilst eee will have the value F2.
Can someone possibly tell me how to achieve that, either to be actioned whenever the query is processed or as a one-off update of the original table.
