Hi All.

My first attempt at a macro, basically it Transposes the data from 2 rows, a1:a14 and b1:b14, into 2 columns but I have x amount of worksheets that I need to run the macro.

TS.JPG

I have tried several ways to do this simple task but it just wont work.

Thank you.

Spacebar.