Multiple columns to one column.

I need to change multiple columns to one column.

Each row has got an ID. and a data. Under each column there are results that crossponds to the ID and the date. I would like to have all the results in one column. This means that instead of having one ID and date I will have multiple ID and date.

I hope I am dezcribing it cleasrly.

Thank you in advance
Echo73

I am attaching the file

Echo73 are you sure the "What you like to have" is right?
In what you have now, you have lots of columns Labelled naam1, naam2 and so on, but "Result" is only ONE per name?

This will work

Please Login or Register  to view this content.

Dear Mike and lancer,

I have tried your VBAs, but couldn't solve the problem. I am not doing it good, I think. I am sending you my original file with some changes, hooping that you are willing to help me.

Thank you so much in advance!

Echo

Give this a try

Please Login or Register  to view this content.

Hallo Mike,

Thanks for your reaction!

It did work, but not completely.

The names have become in one column, however the results that correspond to the names are not copied.

In the attached excel file, I have removed the results because the file was bigger than the allowed quota. But normally under each name there are results that correspond to the ID and the date.

Thank you in advance!

Echo