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

Don't keep re-posting, you have an answer in previous postings!

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

"ash" <[email protected]> wrote in message
news:[email protected]...
>
>
> 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
>