break a single column into multiple based on empty row or specific character

[#1]

Hi,

can someone provide advice?

I have a column with structure below:
1

2

3

a

b

c

d

e

f

xx

yy

zz

is it possible to divide to multiple columns based on empty row (or a repeated same character) 

1 a xx

2 b yy

3 c zz

   d

   e

   f

[#2]

Hi,

One way to achieve this is creating an indicator column with the formula below:

If( Row() == 1,
	1,
	If( Is Missing( Lag( :Column 1, 1 ) ),
		Lag( :SPLIT, 1 ) + 1,
		Lag( :SPLIT, 1 )
	)
)

And then split your original column (Split Table) using the new indicator column as Split By variable (see attached)

I hope it helps.

Best,

TS 

[#3]

Hi TS, This is helpful. Thanks for your reply.