Mac platform NeoOffice spreadsheet realizes data transpose function

Recently, because of working reasons, the need to convert a large number of horizontal data in the spreadsheet to vertical, in Microsoft Office Excel in the paste-and-switch feature can achieve this effect, but my computer does not install Ms Office, only NeoOffice, Find no transpose This function, how to do?

Actually can use function transpose to realize, the method is very simple: =transpose (xx:xx), then press Cmd+shift+enter, Fix! Where xx:xx refers to the form area you want to transpose, and of course this technique applies to vertical and horizontal. Iwork in the numbers can also achieve this function, but also the use of functions, but I have not studied carefully, we can try their own.