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
Ash