Apply formula in row and transpose to column

[genomix]

If i have a row like this: [TABLE="width: 581"]
<tbody>[TR]
[TD="class: xl66, width: 83"]Oct-2017[/TD]
[TD="class: xl66, width: 83"]Nov-2017[/TD]
[TD="class: xl66, width: 83"]Dec-2017[/TD]
[TD="class: xl66, width: 83"]Jan-2018[/TD]
[TD="class: xl66, width: 83"]Feb-2018[/TD]
[TD="class: xl66, width: 83"]Mar-2018[/TD]
[TD="class: xl66, width: 83"]Apr-2018[/TD]
[/TR]
</tbody>[/TABLE]
The contents of this row can vary - I want to be able to create a dashboard to copy the contents of this row and transpose to a column

Is this possible?

 

[sheetspread]

The transpose function will do this