Re-arranging cell values

[nawas]

Dear Experts,

Kindly note, i have an excel workbook which contains KPIs for different job titles and i need to re-arrange it by copying all the objectives in each rows with its weight.


for ease of understanding i have attached the workbook which contains two sheets, the first sheet contains data which i need to re-arrange and the second sheet is the expected result.

This workbook contain KPIs for many titles and all should be captured in the prescribed format.

Hope i can achieve this with the help of macro and highly appreciate your support..


Regards,
Nawas

[Akuini]

Hi, Nawas.
Try this:

Please Login or Register  to view this content.

[nawas]

Thanks Akuini for your supports, i have tried this but it doesn't work.

[Akuini]

Hm, it worked on your sample workbook. Try it:

[YasserKhalil]

Hello
I have tested Akuini's code and it is working very well... What is happening with you? Have you encountered errors? Click 'Debug' and copy the yellow lines that causes the error ..

[nawas]

Thanks a lot and it worked well... initially triggered some issues, may be its my fault.

Indeed its a great solution..

[Akuini]

You're welcome & thanks for replying

[nawas]

Dear Akuini,

I would like to add one more request,, what if i need to add two more objectives in Column F which is "Competencies & Leadership".

I have enclosed the sheet and highlighted in YELLOW my desired result. Kindly seeking your assistance..

Thanks

[nawas]

Any luck on the above request..

Just need to include two more objectives which mentioned in the Column F for each table.

[Akuini]

Ok, try this:

Please Login or Register  to view this content.

[nawas]

Many Thanks .. very much appreciated your support

[Akuini]

You're welcome & thanks for replying