Solved

Excel Transpose :A simple favour from a hassled man!

Posted on 2014-04-15
2
131 Views
Last Modified: 2014-04-15
See TWO sheet attached.

I am very hassles and have struggled with this for over an hour!

I know it is not the EE ethos but could someone transpose BOTH the top rows of these sheets.

I.e. make the left to right values appear top to bottom.
Transpose.xlsm
0
Comment
Question by:Patrick O'Dea
2 Comments
 
LVL 50

Accepted Solution

by:
Rgonzo1971 earned 500 total points
ID: 40001458
HI,

Copy the range you want to transpose then select the cell where to dispose the data

Use Paste Special / transpose

Regards
TransposeV1.xlsm
0
 

Author Closing Comment

by:Patrick O'Dea
ID: 40001544
Much appreciated.
I was having a mental blank.
0

Featured Post

Active Directory Webinar

We all know we need to protect and secure our privileges, but where to start? Join Experts Exchange and ManageEngine on Tuesday, April 11, 2017 10:00 AM PDT to learn how to track and secure privileged users in Active Directory.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Drop Down List with Unique/Distinct Values (Part II - ComboBox or ListBox and Data Validation List Bonus!) David Miller (dlmille) Intro This article focuses on delivering unique, sorted lists to list objects (e.g., ComboBox, ListBox) and Dat…
Introduction While answering a recent question (http:/Q_27311462.html), I created an alternative function to the Excel Concatenate() function that you might find useful.  I tested several solutions and share the results in this article as well as t…
The viewer will learn how to create two correlated normally distributed random variables in Excel, use a normal distribution to simulate the return on different levels of investment in each of the two funds over a period of ten years, and, create a …
This Micro Tutorial will demonstrate in Google Sheets how to use the HYPERLINK function to create live links inside your spreadsheet.

828 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question