How to Reorganise Data in specific format from verious columns to Row

[expl]

Dear Friends


I have this spreadsheet where there are thousands of sets of data . Kindly refer to the spreadsheet for better understanding

All I want to do is transpose each set of data from the columns to their respective rows.

Is there a way I could automate / reorganised this through a formula or a macro.

Please let me know...this will save me a lot of time

Regards

[mike7952]

This should do it I noticed some of you data is more then 8 row groups. So you will need to address those.

Please Login or Register  to view this content.

[FDibbins]

The attached was created for another member for basically the same situation as you have. with a little bit of adjusting, im sure you can modify the formulas to suite your needs.

let me know how you make out please?

[expl]

Dear Friend..

I'm really very much thankful to you for your kind help, if you dont mind once again in need of your help...

Method used by you to reorganize the data is 100% perfect, I request you to extend your help once again please.

I have placed new thread on under mentioned link, and data is almost same as you solved last time.

can you please do that for my new thread at under mentioned link..

http://www.excelforum.com/excel-prog...html?p=2978051


I'll be very much grateful to you for your kind support.

Lots of thanks in Advance

Regards

Ashish Parashar

This should do it I noticed some of you data is more then 8 row groups. So you will need to address those.

Please Login or Register  to view this content.