Restructuring from long to wide/horizontal format in SPSS

Although it is fairly atypical with longitudinal or repeated measures data, there may be occasions where you seek to restructure your data from long format to wide/horizontal format. This video covers how to do this in SPSS. A copy of the data can be downloaded here: drive.google.c...
The data is associated with this book: www.routledge....

[@trung11782]

Thank you very much, Mike. I have spent weeks trying to do so before I watched this video. You save me!

[@jules6731]

This is amazing, thank you so much Mike! :)

[@jessperry1703]

Hi Mike, thank you for this tutorial. I wondered if restructuring long > wide is the necessary process to compute variables? I have longitudinal data (and hence, long-format), but many of the 'cases' need to be scored together as they are part of a scale, and I'm struggling to see how to achieve this. I have computed variables to create scale scores in wide-format, but struggling to understand how to do this in wide format. Any advice would be appreciated!

[@cristianyseppe5611]

Thank you, thank you, thank you...

[@niels6741]

thank you!

[@juliema289]

Hi Mike, thank you for sharing this video. I am doing a GDP and stock price correlation in 5-years currently. I am struggling how to create data in SPSS. since each year only have 1 GDP number, but many number of stock price (50 stocks). Could you help me on this?

[@Freeheartfreemind]

Please how to do that on excel ?

[@qijialiao2576]

upload excel into SPSS, restructure the data from long format into wide format, save SPSS file as xls format. 🤣