Forum Discussion

powerboss1's avatar
powerboss1
Frequent Visitor
1 month ago
Solved

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...
  • jgeddes's avatar
    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.