No, I want all the dates. Yes there are a lot of missing values because in those months those firms didnt have any returns. ... View more

I've attached the file. I tried the above code, but because the dates along the first row are being treated as variable name instead of observations. So i don't know how to transpose them ... View more

Hi, I apologize but This is the data I have: Already in a excel sheet ill be importing. This is a small subset of what i have. Name Ticker 7/2019 6/2019 5/2019 4/2019 A PSPTX 1.41 7.47 -6.68 4.26 B PTOAX 1.34 7.33 -6.62 4.24 C PSOCX 1.39 7.23 -6.72 4.16 D EAGMX 1.45 1.46 0.56 0.21   Id like it this way:   Name Ticker   7/2019 A PSPTX 1.41 7/2019 B PTOAX 1.34 7/2019 C PSOCX 1.39 7/2019 D EAGMX 1.45 6/2019 A PSPTX 7.47 6/2019 B PTOAX 7.33 6/2019 C PSOCX 7.23 6/2019 D EAGMX 1.46 5/2019 A PSPTX -6.68 5/2019 B PTOAX -6.62 5/2019 C PSOCX -6.72 5/2019 D EAGMX 0.56 4/2019 A PSPTX 4.26 4/2019 B PTOAX 4.24 4/2019 C PSOCX 4.16 4/2019 D EAGMX 0.21 The dates along the rows not have a variable name as I had shown in my original post, so i am not able to transpose them. Could you provide help for this situation? ... View more