transform data from rows to columns

3 次查看(过去 30 天)
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?

采纳的回答

Shameer Parmar
Shameer Parmar 2016-6-21
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'
  1 个评论
Myurathan Kajendran
Thank you so much for your quick reply. I will try and get back. Thanks again

请先登录,再进行评论。

更多回答(0 个)

类别

Help CenterFile Exchange 中查找有关 Portfolio Optimization and Asset Allocation 的更多信息

产品

Community Treasure Hunt

Find the treasures in MATLAB Central and discover how the community can help you!

Start Hunting!

Translated by