you can transpose (which is really a swapping of the row and column) using the OFFSET() function. Are you wanting to turn a row into a column? or a column into a row? or are you wanting to transpose a who table?
In either case you can have the original data in a table (let's call it Data) and the transposed data in a new table... lets called it Trans
The table on the right is "Trans"
A1=OFFSET(Data :: $A$1, COLUMN()-1, ROW()-1, 1, 1)
select A1 and fill to the right as needed
select A1 thru the end of the row, then fill down as needed