Dyanmically Transpose Year fields from rows into columns

TanvirAhmed

Hi,

How would I transpose the below dynamically to get years as columns instead of rows (without filtering the years and joining on the common field period etc). I want the years to flow through automatically when there is a new one, instead of adding a filter everytime. Essentially I want it how its displayed in the second screenshot.

Thanks!

Example.yxmd

OllieClarke

Hey @TanvirAhmed this workflow should get you where you need to be:

Example.yxmd