Forum Discussion
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 the client name will show up 12 times (Once for every month of the rolling 12 month cycle). I want to get the data to read as the following column headers: Client, GP, Year - Date
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.
2 Replies
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.Exactly what I was looking for! Thank you!
