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 data


Note that the number of steps under the steps column here vary from 1
to 10.


Thanks in advance
Ash

You gotten several responses to your other posts.

ash wrote:

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 data

Note that the number of steps under the steps column here vary from 1
to 10.

Thanks in advance
Ash

--

Dave Peterson