transform data from rows to columns
2 views (last 30 days)
Show older comments
Myurathan Kajendran
on 21 Jun 2016
Commented: Myurathan Kajendran
on 21 Jun 2016
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?
0 Comments
Accepted Answer
Shameer Parmar
on 21 Jun 2016
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'
More Answers (0)
See Also
Categories
Find more on Multirate Signal Processing in Help Center and File Exchange
Products
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!