Transpose headers from table excluding the first header?

Hi,

I have a table set up in excel and I want to transpose all the headers into another worksheet but not include the first column.

I have worked around it bu using =TRANSPOSE(tableName[[#Headers],[column2]:[column36]])

and then Crtl + Shift + Enter

However if I add a column to the table at the end (call it column37) it obviously isn't included in the transpose as that is only transposing upto column36.

If I use the formula =TRANSPOSE(tableName[#Headers]) it includes the header of Column1 which I don't want.

Is there a workaround for this?

Many thanks,