Using data in a format similar to the one below, how would I insert additional entire rows below all cells with blanks?
1 A
2
3 B
4
5 C
I essentially want the following output after inserting
1 A
2
3
4 B
5
6
7 C
8
9
I can select blanks using regular expression “^$”, however, there is no option to insert rows. CTRL++ does not work.
Just add an auxiliary column of row indexes. Add line numbers after which you want to insert an empty line (It doesn’t matter whether an empty row is added before or after an empty row - in any case, you will get two empty rows instead of one). Sort your table by this column. After that, the auxiliary column can be deleted.
Exactly what I wanted. Thank you for this. I was expecting this to be possible using basic point and click though […]