Shift/transpose values (Macro needed)

Hi everyone,

I'd like to shift/transpose data from one sheet and produce something in another sheet so I can make a csv to import it in a database.

What I'd like to achieve is this: (don't look at the dashes, those are just so I can format it a bit to make it look like a table)

Clientcode--------Name--------Language----------Country
123-------------------Alex-----------English------------England
456-------------------Bart-----------French-------------France
999-------------------Charlie-------Greek--------------Greece

and let a macro produce this:

Name----------Alex---------123
Language-----English-----123
Country--------England----123
Name-----------Bart----------456
Language------French------456
Country---------England----456
Name------------Charlie-----999
Language------Greek-------999
Country---------Greece-----999


EDIT:
I added a better example in the excel file.
(I didn't know that spaces would be trimmed in the post)


Does anyone know how to achieve this?

Thank you very much.

Regards,

Gosa

If you are satisfied with the solution(s) provided, please mark your thread as Solved.

How to mark a thread Solved
Go to the first post
Click edit
Click Go Advanced
Just below the word Title you will see a dropdown with the word No prefix.
Change to Solved
Click Save

Thats strange you should be able to do ti anyway its Done