Hi,
I am looking for help in transposing data:
My data is in the format as below:
pre-transpose.png
When transposed I get the result as below:
post-transpose.png
Where some data is lost
Ideally I should get all the rows transposed as columns as below:
Required Result.png
Any help in this is much appreaciated.
Just transpose the last two columns.
@ hoyasaxa215, if the OP new how to do that, they would not be asking here
@ suryasai Please upload a sample of your workbook, not a picture of your data.
Pictures are pretty much impossible to edit, and no-one wants to re-type your data for you
Also, not all members can upload picture files (Company firewalls and stuff)
Your workbook should show a small desensitized example of the data you are working with and a manual mockup of the expected results.
1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
2. If your question is resolved, mark it SOLVED using the thread tools
3. Click on the star if you think someone helped you
Regards
Ford
This thread already exists, and was updated today...?
http://www.excelforum.com/excel-gene...ml#post3755500
You should hit F5, because chances are I've edited this post at least 5 times.
Example of Array Formulas
Click the * below on any post that helped you.Originally Posted by Jacc
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks