View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.misc
ash
 
Posts: n/a
Default Hi all need some help in excel transpose

Hi Bob

The data is in the following format


Summary
Summary1
Steps
1)Steps1
Expected Result
Expected Result1
Keywords:
Keywords1
Summary
Summary2
Steps
1) Steps2
2) Steps2
3) Steps2
Expected Result
Expected Result2
Keywords:
Keywords2


I need it as :


Summary Steps Expected Result Keywords:
Summary1 1)Step1 Expexted1
Keywords1
Summary2 1)Step2 Expexted2
Keywords2
2)Step2
3)Step2
Summary3 1)Step3 Expexted3
Keywords3


Any help on this will be great.


Thanks
Ash