topic Re: break a single column into multiple based on empty row or specific character in Discussions

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

dadawasozo — Sat, 10 Jun 2023 23:37:32 GMT

Hi,

can someone provide advice?

I have a column with structure below:
1

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

Thierry_S — Sat, 25 Sep 2021 06:15:05 GMT

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,

dadawasozo — Sat, 25 Sep 2021 15:08:18 GMT

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