Numbers rows & columns

Take a look at the transpose function. It is a bit complicated to use so be sure to read the detailed notes about the function. The complete descriptoin includes examples.

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