hello out there, I am trying to transpose the entire table... As i am writing =transpose(A1:G4) its giving me the output as 0 Monday Tuesday Wednesday 0 0 0 Monday Tuesday Do i need to transpose header wise??