Over the last year or so I have been converting a number of spreadsheets from Excel to Numbers. This had gone well until I wanted to transpose some data sets from columns to rows. In Excel this had been simple using 'copy' - 'special paste' and 'transpose'. I can't find the equivalent procedure in Numbers - anyone help please?
The only capability I'm aware of is to transpose the entire table. If this is a one-time conversion to Numbers then you might be happy to bodge it (depending on how advanced your sheet may be):
Create a new, temporary table that's the size of the data cells to be transposed. Copy/paste the data into that table and transpose it (Table > Transpose Rows and Columns (near the bottom of the menu)), then copy it back.
This glosses over any interactions between the transposed cells and the remainder of the table, you'd need to update them manually. Apologies if this is too simplistic.
Howard Richings 