- You are here
- Microsoft Newsgroups Archived.At
- microsoft.public.excel.misc
- 2006 May
- Hi all need some help in excel transpose

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

- Re: Hi all need some help in excel transpose posted by Ash on 2 May 2006
- Re: Hi all need some help in excel transpose posted by Bob Phillips on Tue, 2 May 2006