Can we please have Univot option just like we have pivot under transformation ?
Option like we have in excel using power query editor where can just select the columns to be unpivoted and select the option Unpivot Columns and everything is done in a few seconds. I wish Gainsight had it but they can take it a feature request.
For example, if you look at this image; ID1 has values for ABC and XYZ and ID2 has only for DTE. Left hand side the data we have and on the right hand side is what we need to have
Thanks,
