View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
ash
 
Posts: n/a
Default cell by cell transpose



The datai have 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 in advance
Ash