Re: $$Excel-Macros$$ Transpose column to row basis column heading

2014-07-17 Thread Prakash Gusain
Yes they are static On Thursday, July 17, 2014 3:21:37 PM UTC+5:30, Vabz wrote: Is header in Raw data static? On Wed, Jul 16, 2014 at 5:22 PM, Prakash Gusain gusain...@gmail.com javascript: wrote: Hi All, Attached file has two tabs (Raw Data OutCome). What I am trying to achieve is

Re: $$Excel-Macros$$ Transpose column to row basis column heading

2014-07-17 Thread Vaibhav Joshi
Ok, here you go..From First sheet press Blue button to run Macro.. Cheers!! On Thu, Jul 17, 2014 at 5:01 PM, Prakash Gusain gusainprak...@gmail.com wrote: Yes they are static On Thursday, July 17, 2014 3:21:37 PM UTC+5:30, Vabz wrote: Is header in Raw data static? On Wed, Jul 16,

$$Excel-Macros$$ Transpose column to row basis column heading

2014-07-16 Thread Prakash Gusain
Hi All, Attached file has two tabs (Raw Data OutCome). What I am trying to achieve is transposing column F G of the Raw Data onto OutCome tab. The catch is to transpose basis the role which is listed as heading of Outcome tab. If in the list we have more than open person with similar role,