Issue
Unable to use the [Rows to Columns] Pivot Step once you add a [New Rows] Step before it.
Just like the image below, it is impossible to add any fields in the pivot step after the [New Rows] Step.
However, if you only use [Rows to Columns] without the [New Rows] pivot step, it is OK to pivot.