software

I need a macro to transpose data in the excel.The data that i have is
in the following format:

Summary
Some data
Steps
1)Some data
2)Some data
Expected Result
Some data
Keywords
Some data

This is repeated in the next row and so on..

I need it in the following format

Summary Steps Expected Result Keywords
somedata 1)Some data Some data Some data
2)Some data
Summary Steps Expected Result Keywords
somedata 1)Some data Some data Some data
2)Some dataNote that the number of steps under the steps column here vary from 1
to 10.Thanks in advance
AshYou gotten several responses to your other posts.

ash wrote:
gt;
gt; I need a macro to transpose data in the excel.The data that i have is
gt; in the following format:
gt;
gt; Summary
gt; Some data
gt; Steps
gt; 1)Some data
gt; 2)Some data
gt; Expected Result
gt; Some data
gt; Keywords
gt; Some data
gt;
gt; This is repeated in the next row and so on..
gt;
gt; I need it in the following format
gt;
gt; Summary Steps Expected Result Keywords
gt; somedata 1)Some data Some data Some data
gt; 2)Some data
gt; Summary Steps Expected Result Keywords
gt; somedata 1)Some data Some data Some data
gt; 2)Some data
gt;
gt; Note that the number of steps under the steps column here vary from 1
gt; to 10.
gt;
gt; Thanks in advance
gt; Ash

--

Dave Peterson