Hi all need some help in excel transpose

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

See response in .excel

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

"ash" <aswin_aditi@hotmail.com> wrote in message
news:1146551736.602527.64340@v46g2000cwv.googlegroups.com...
> 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
>

Hi Bob

The data 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
Ash

Hi Bob

The data 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
Ash

Sorry 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


Thanks,
Ash

See further response in .excel.

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

"ash" <aswin_aditi@hotmail.com> wrote in message
news:1146557668.556792.147600@v46g2000cwv.googlegroups.com...
> Sorry 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
>
>
> Thanks,
> Ash
>