J jayalaxmi Active Member Apr 5, 2015 #1 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?? Attachments link.xlsx link.xlsx 8.3 KB · Views: 0
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??
J jayalaxmi Active Member Apr 5, 2015 #3 yes i had tried pressing cntrl+shift and enter.. it is giving me output as above..not like urs.. Regards, Jaya
yes i had tried pressing cntrl+shift and enter.. it is giving me output as above..not like urs.. Regards, Jaya
wudixin96 Member Apr 5, 2015 #4 You should select range a7:d13 ,before entering the array formula shoud not enter array formula in A7,then drag it
You should select range a7:d13 ,before entering the array formula shoud not enter array formula in A7,then drag it
