calculate standard deviation based on values in multiple columns alteryx

[RK3]

Hi all, 

Still quite new to the Alteryx ways of working...

I am struggling with finding a shorter and smart way to calculate the standard deviation for each NAME based on values in multiple columns (Days X), without writing the long formula in the Formula tool... For example, my database looks like: 

NAME	Day 1	Day 2	Day 3	Day 4	Day 5	Day 6	Day 7	Day 8	Day 9	Day 10	Day 11	Mean	Std. Dev
Anne	0.77	0.83	0.83	0.83	0.84	0.82	0.82	0.83	0.81	0.79	0.81	0.816364	?
Tom	0.84	0.85	0.85	0.85	0.85	0.86	0.86	0.85	0.85	0.85	0.85	0.850909	?
Jan	0.99	0.99	0.99	0.99	0.99	0.99	0.99	0.99	0.99	0.99	0.99	0.99	?

The Summarize tool also does not provide what I am looking for so far.

Anyone tips to do this in a smart way? 

Thanks!

[jdunkerley79 · Accepted solution]

Welcome to Alteryx.

The easiest way is to transpose you data then summarise and finally join back to the original.

The transpose makes the data row based which means the summarise works.

The join then puts the extra columns back on the original set.

Sample attached