Alteryx filter only until the first blank row

[DanielCarro]

Hi,

I have a spreadsheet which has rows, then there is a blank row and then it continues with further numbers; but I just need the data until the first blank row (the rows can increase but there will always be a blank row), and just ignore everything else below the blank row

This is what I have

ID	COUNTRY	SALES
1	SPAIN	1000
2	GERMANY	2000
3	GERMANY	3000
	SURPLUS	56000

I just want to extract

ID	COUNTRY	SALES
1	SPAIN	1000
2	GERMANY	2000
3	GERMANY	3000

Kind Regards,

Daniel

[Felipe_Ribeir0]

Hi @DanielCarro 

One way of doing this

[DanielCarro]

Hi Felipe,

I don't get 'Null', I have empty

[Felipe_Ribeir0]

Hi @DanielCarro 

Try this new version

[DanielCarro]

It worked Felipe, thank you very very much

[Felipe_Ribeir0]

Hi @DanielCarro 

I am glad it helped. Please accept my answer as a solution, so the topic can be considered solved :)

Thanks!