cell by cell transpose

Giganews Newsgroups
Subject: cell by cell transpose
Posted by:  Ash (aswin_adi…@hotmail.com)
Date: 2 May 2006

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

Replies