help transforming data

[jhouseslu]

I have a summary tool that transforms the data in the format in the attached image. I would like to get the data transformed to my desired result but have not been able to figure out how. Is this possible?

Summary Tool:
Term	Schoolname	Apps	Admits	Deposits
Fall 2020	School 1	116	34	1
Fall 2020	School 2	1311	448	2
Fall 2020	School 3	450	151	1
Fall 2021	School 1	200	50	2
Fall 2021	School 2	1300	450	3
Fall 2021	School 3	399	125	2

Desired Result:	Fall 2020	Fall 2021
Schoolname	Apps	Admits	Deposits	Apps	Admits	Deposits
School 1	116	34	1	200	50	2
School 2	1311	448	2	1300	450	3
School 3	450	151	1	399	125	2

[jhouseslu]

To clarify:

For the desired results, the first set of columns (Apps, Admits, Deposits) should be the results for Fall 2020.

The second set of columns should be the results for Fall 2021.

[TheOC]

hi @jhouseslu 

I have achieved something very close to your target output:

Please let me know if i can be of any further help!

[Qiu · Accepted solution]

@jhouseslu 
A sample flow is attached here for your confirmation.

[jhouseslu]

Worked like a charm. Nice and simple. Can't believe I overlooked this.

[TheOC]

hi @jhouseslu 

Glad you got it sorted!

Cheers,