Hi guys,

I've got a larger spreadsheet that I am having trouble writing a macro to transpose columns into rows. Please see the attached xls file. I've got two sheets, a "current" sheet and then an "expected" one.

Thanks in advance for your help.Transpose.xlsx