Thanks for your reply.
I chose a different column for the ID columns of the transpose transform, it worked. I supposed the original column i wanted to transpose must have some issues, so transpose wasn't allowed. I didn't have time right now to figure out what was the cause. I am able to transpose now so i am happy as i am chasing time.
It might be the original column had too many characters or other characters such as: (.) , (-)