Hi there, I am wondering how I Unpivot data. What I mean, is I would like this: NameCountA2B1C3 to be transformed into this: NameCountA1A1B1C1C1C1 Thanks!

Unpivot / Reverse Pivot data

Hi there,

I am wondering how I Unpivot data. What I mean, is I would like this:

to be transformed into this:

Thanks!

Preparation

A batch macro with the Generate Rows tool will do this.

A batch macro with the Generate Rows tool will do this.

Hey Philip,

This works a treat. Thanks so much!

Very green follow up questions if you have the time (sorry - first day using alteryx).