break a single column into multiple based on empty row or specific character
Hi,can someone provide advice?I have a column with structure below:
123 abcdef xxyyzz
is it possible to divide to multiple columns based on empty row (or a repeated same character) 1 a xx2 b yy3 c zz d e f