Hi all need some help in excel transpose

Giganews Newsgroups
Subject: Hi all need some help in excel transpose
Posted by:  Ash (aswin_adi…@hotmail.com)
Date: 1 May 2006

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

Replies