Summarize data

[SylviaK]

Hi, 

I am trying to  get Output 1 and Output 2 based on the preceding columns. Can someone pls help?

Many thanks, 

Sylvia

[fmvizcaino · Accepted solution]

Hi @SylviaK ,

You can do that with the transpose + summarize combination as shown below.

BEst,

Fernando Vizcaino

[Maskell_Rascal · Accepted solution]

Hi @SylviaK 

You can get this by using the transpose tool, formula, and summarize tool. See the attached workflow. 

If this solves your issue please mark the answer as correct, if not let me know!

Thanks!

Phil