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

Question

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

dadawasozo · Answer

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

Thierry_S · Answer

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

TABLE_SPLIT on SPACE.jmp