Solved

Transpose Data II

Posted on 2013-06-08
2
174 Views
Last Modified: 2013-06-13
On the attached sample file, I need to flip the data from table 1 into the format of table 2.
I am finding that I am not able to use Transpose due to having some cells merged.
If possible I would like to have some VB code which I can insert into each sheet to accomplish this.

Thank you in advance

ssaqibh...I am unable to make this question private, sorry

Thank you,

Edwin
Sample-Table2.xlsx
0
Comment
Question by:gixxer1020
2 Comments
 
LVL 43

Accepted Solution

by:
Saqib Husain, Syed earned 500 total points
ID: 39231182
=IF(INDEX($C$4:$P$7,MATCH($B11,$B$4:$B$7,0),MATCH($C11,$C$3:$P$3,0)+($B11=""))="","",INDEX($C$4:$P$7,MATCH($B11,$B$4:$B$7,0),MATCH($C11,$C$3:$P$3,0)+(COLUMN()=5)))
0
 

Author Closing Comment

by:gixxer1020
ID: 39246790
Thank you....works like a charm

Edwin
0

Featured Post

Highfive Gives IT Their Time Back

Highfive is so simple that setting up every meeting room takes just minutes and every employee will be able to start or join a call from any room with ease. Never be called into a meeting just to get it started again. This is how video conferencing should work!

Join & Write a Comment

A little background as to how I came to I design this code: Around 5 years ago I designed an add-in that formatted Excel files to a corporate standard, applying different cell colours and font type depending on whether the cells contained inputs,…
Dealing with unintended Excel Active-X resizing quirks (VBA code simulates "self correction") David Miller (dlmille) Intro Not everyone is a fan of Active-X controls in spreadsheets (as opposed to the UserForm approach, the older Form controls …
Viewers will learn the basics of slicers and timelines for both PivotTables and standard Excel tables in Excel 2013.
This Micro Tutorial will demonstrate in Microsoft Excel how to add style and sexy appeal to horizontal bar charts.

707 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

Need Help in Real-Time?

Connect with top rated Experts

14 Experts available now in Live!

Get 1:1 Help Now