The OP doesn't show the sample transposed only file but when I ran it the first column was the headers.