I show some necessary checks for converting from the long format to the wide format and I comment on which methods I think are best and which format I think is best.