Multi column count if not empty

[Axis]

Hello everyone, 

A small question for you because I'm stuck. 

If I have a table like this but with a large number of columns (>200) and large number of rows :

Column 1	Column 2	Column 3	Column 4
45	4	Apple
21			Green
		Orange	Yellow
12		Apple

I'm looking for a way to creath a 5th column that will count the not empty values in the row to have a table like this :

Column 1	Column 2	Column 3	Column 4	Countif not empty
45	4	Apple		3
21			Green	2
		Orange	Yellow	2
				0
12		Apple		2

Do you have a way to do so for a large table? 

Thanks a lot for your help. 

Best regards,

Axis

[Emil_Kos · Accepted solution]

Hi @Axis,

I have prepared a workflow for you:

The key was to use the transpose tool.

Please see the output below:

[Axis]

Hi @Emil_Kos , 

Thanks a lot for your help, that worked perfectly. 

Have a nice day. 

Best regards,
Axis