| a hi |
a |
| b hi |
hi |
| c hi |
b |
| hi | |
| c | |
| hi |
In the data in column K, I want to divide the contents of cells containing newlines into rows! Can this be replaced using a formula?
CodePudding user response：
Try:
=FLATTEN(SPLIT(TEXTJOIN(CHAR(10),1,K:K),CHAR(10)))
