• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

transpose hurdle

jayalaxmi

Active Member
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
    8.3 KB · Views: 0
yes i had tried pressing cntrl+shift and enter.. it is giving me output as above..not like urs..

Regards,
Jaya
 
You should select range a7:d13 ,before entering the array formula
shoud not enter array formula in A7,then drag it
 
Back
Top