Dataset transformation

Question

I have a SPSS dataset with 3 columns ("companies", "date", "return") like this:

Now I would like to transform it so that only dates show up in a row and each company return for a given date is in a separate column, like this:

Is there an easy way to do that in either SPSS or R?

Thanks for the help!

Welcome to Stack Overflow. Please avoid posting pictures of data. Use `dput` instead to make reproducible example(s). [Give this link](http://stackoverflow.com/questions/5963269/how-to-make-a-great-r-reproducible-example) a read. Thanks — Sotos, May 05 '16 at 11:38

score 0 · Answer 1 · answered May 05 '16 at 16:37

0

In SPSS:

sort cases by date companies.
casestovars /id=date /index=companies /separator="_".

answered May 05 '16 at 16:37

eli-k

1 Answers1