Forum Discussion
powerboss1
1 month agoFrequent Visitor
Transpose Title Row ONLY
Hello, I am wondering if it is possible to transpose a title row without having anything else transpose. In my screenshot there are several client's with financial information listed below. Ideally t...
- 1 month ago
It sounds like you are looking for the Unpivot function.
On the Transform Ribbon you will find the Unpivot Columns button. In this instance you should select the client name columns and then choose the 'Unpivot Selected Columns' option. This should get the result you are describing.
jgeddes
1 month agoSuper User
It sounds like you are looking for the Unpivot function.
On the Transform Ribbon you will find the Unpivot Columns button. In this instance you should select the client name columns and then choose the 'Unpivot Selected Columns' option. This should get the result you are describing.
- powerboss11 month agoFrequent Visitor
Exactly what I was looking for! Thank you!