transform data from rows to columns

I have a CSV data file. That looks like below company-----Date--------Price ComA--------15/05/2015--20.5 ComA--------15/06/2015--30 Comb--------15/05/2015--15

I want the companies to be in the columns and dates to be rows. How to do that?

Answer 1

[Shameer Parmar]

If you have variable 'data' like..

 data = {'company-----Date--------Price', 'ComA--------15/05/2015--20.5', 'ComA--------15/06/2015--30', 'Comb--------15/05/2015--15'}

then

following command give you the expected result in column..

 data = data';

output will be as follows:

 data = 

    'company-----Date--------Price'
    'ComA--------15/05/2015--20.5'
    'ComA--------15/06/2015--30'
    'Comb--------15/05/2015--15'

[Myurathan Kajendran]

Thank you so much for your quick reply. I will try and get back. Thanks again