I know Macros will be my answer but not sure how to figure this one out

[Sfakia81]

I am stumped on what type of workflow would get me to my end result. I have a dataset that is significantly larger than this and I'm tyring to figure out an efficient way in Alteryx. I appreciate any suggestions. I am a beginner with Alteryx but have created batch macros for obtaining data from multiple files. I think an iterative macro may be needed here and am currently looking into it.

[geraldo]

@Sfakia81 

I believe that the transpose tool solves your problem

[Sfakia81]

You are correct! I just achieved what I needed. Thank you!