Flip Select Column and Header - Transpose/Crosstab?

Question

I have a set of data containing 50+ headers for which 120+ months of data are provided. It is currently oriented the wrong way. I prepared the example below for what I am trying to accomplish. Header B = the Month value. I want the columns to be the months, but I also want them to stay with their respective Type.

Start:

Goal:

Select Column and Header Flip.yxmd

atcodedog05 · Accepted Answer

Hi @PeteLacz

Here is the fixed workflow. The changes were needed to be made in transpose and crosstab

Output:

Hope this helps 🙂 Feel to ask if you have any questions

If this post helps you please mark it as solution. And give a like if you dont mind 😀👍