Is there any OOTB rule available for Transpose Column values as Row values?

We are looking to transpose row data of a table into columns of another table as explained below

Example:

Column1 Column2           As     Column1      100       101      102       103 

100          Test1                        Column2     Test1    Test2    Test3   Test4

101          Test2

102          Test3

103          Test4