Skip to Content

Tranpose rows and to column using RTTS

Aug 25, 2017 at 10:27 PM


avatar image

Hi expert, I have searched a lot in tranpose rows to columns using RTTS but could not find what I need, say I have an input for a monthly bucket from Jan to Dec. Each month, I have a table with Cust No, Name, Revenue 1, Revenue 2, Percent comparison between Revenues. I want to output a report showing the column header as the month, under each month will be 5 columns: Cust No, Name, Rev 1, Rev2, %comparison. It seems like the input dynamic table can be a table of deep structure for each monthly bucket but I just do now know how to tranpose the monthly row to column. I found the blog by Susmitha Susan Thomas:

and Naimesh Pastel blog in

but they just have only one column under each column header. Here is my input picture

And the output should be like this, the month can be expanded up to December. Thank you very much for your help.

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

0 Answers