• 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.

Can you flip or rotate data withour pasting like a picture

I want t be able to copy and paste some cells on to a sheet except i want to rotate everything and keep the number 1 in a cell by itself. Is this possible. In the picture I have the number 1 in columns BCDE and they go down to row 42. I want to rotate everything without having to do it 1 cell at a time like the picture in columns G : P

Is this possible using excel or a formula? I know I can go to picture mode and do this but I need to be able to color code everything
 

Attachments

  • flp.jpg
    flp.jpg
    95.2 KB · Views: 11
I guess you can use camera shots , what ever color coding you do to the original table will be reflected in the camera shot....
 
Thanks Hui, I will take a look at this.

Narayan, I will upload one and look at what Hui sent me as well, I may be able to figure it out from this article
 
Back
Top