I will not have more then 200 rows of data, the code that you done it's exactly what I want, the only problem is that the text in column A and B change the file to file isn't possible to do this in a way that EXCEl recognize automatic what are the text and then make the transpose.

thanks

Ismael