I have say a column A in a table which have some emty cells like following :
AB345 AC545 XY675 VY987 AC879
I want to to fill the empty cells with unique values by taking an expression and incrementing it all over the empty cells, in a result like :
AB345 XX1 AC545 XX2 XY675 XX3 VY987 XX4 XX5 AC879
I have tried selecting the empty cells from the table column header, but when I drag the mouse from the first empty cell, it will also overwrite the non empty ones with the incremental values.
How can I achieve this ?