Rearrange Data

**Madan** · 03-09-2010, 06:59 AM

Hi All,

Please help me to get the desired result in the attached spreadsheet.

Thanks in advance
Madan

**contaminated** · 03-09-2010, 07:18 AM

Hi Try this macro out

Please Login or Register  to view this content.

**Madan** · 03-09-2010, 07:31 AM

Thanks.
But the macro doesn't seem to work properly.

Is it possible to rearrange the data without using macros?

Madan

**teylyn** · 03-09-2010, 07:40 AM

Madan, please take the trouble to explain your issue in the text on the post, not only in the attachment. This will help our members decide whether they want to download the attachment or not.

thanks.

**Madan** · 03-10-2010, 01:38 AM

Hi Teylyn,

I have the existing data wherein ProductA(in cell B3) has two subproducts, namely ProductAA(in cell C4) and ProductAB(in cell C8).
Again Product AA has multiple products(number of products will change everytime) which is specified in cells D5 to D7.

I would like to rearrange my data in such a way that there is no blank cell next to ProductA(in Cell C3).
The same holds good for ProductAA, ProductAB.

I am not well versed with macros, hence, it would be better if i can use some excel functions to achieve this.

Hope this clarifes my issue.

Regards
Madan