Transposing columns into rows

[Anonymous]

Before 

col1      col 2       col 3
12        9             7

need this as output(after)
col1    12 
col 2    9 
col 3    7

Please help me out its urgent.

[Anonymous]

Hi Sunny, 
tsplitrow can be used for this purpose.Please follow below steps
   




Thanks,
Nuvvula

[Anonymous]

Hey thanks for your response but as per your solution there is redundancy ,the output i needed is somewhat different
example:
This is my schema as of now
Header_Name          Header_Salary
Samy                     99990
Bruno                    76435


output needed

Header_Name         |      Samy     |      Bruno
Header_Salary        |     99990     |      76435
So what component should i use to get this kind of output?

[Anonymous]

is there any solution?

[Anonymous]

Hi [font=Verdana, Helvetica, Arial, sans-serif] sunny.sehgal04[/font]


[font=Verdana, Helvetica, Arial, sans-serif] Take a look at this KB article converting rows to columns, let me know if you still have any problems.[/font]

[font=Verdana, Helvetica, Arial, sans-serif] Regards[/font]
Shong

[Anonymous]

Hey Shong thanks a lot for responding but my case is quite different form the article on  that link , according to my case the input columns are :
example :
Year              2011      2012       2013   2014
Unemp            22.4       22         11      11.5


So the output i needed is in this format :
Year    Unemp
2011    22.4
2012    22
2013    11
2014    11.5
i'm trying hard to find the solution of the problem but didn't found any Please can you help me  in solving this.

[Anonymous]

Hi  
You gave us different example in your each post, they are completely different cases. Can you please show us your real case? so we can give you an accurate answer.


Regards
Shong

[Anonymous]

Well the data in my file is large enough so, I'm not going to post that here , i posted an example i.e small part of my file previous example was actally data from my file i hope to get a reply from you soon .

[Anonymous]

heyy Shong is there any solution?