I
I have downloaded a bank statement in .csv form and put it into Numbers. How do I reverse ALL the rows and columns so that the earliest date ( and all the information in that row as well) is displayed at the top ( and not the bottom as in the example above?)
Mac Pro1,1 Dual-Core Intel Xeon 3GHz 5GB RAM + L9 + Focusrite Saffire Pro 40, Mac OS X (10.5.8), MacBookPro OS X (10.6.3) 2.66 + M Audio Fast Track Ultra
Convert row 1 to a header row so it is not included in the sort.
Click the Reorganize button.
in the Sort section, choose Column A and Ascending.
All sorts in Numbers sort the rows based on values in one or more columns. You cannot, without special measures, sort a single column.
Regards,
Barry
perfect, thanks Barry for your patience with such a basic question 🙂
M S
Slightly modified version for those wanting to keep row 1 as standard one.
Click the tab A to select entire column A
command click cell A1 to unselect row 1
Click the Reorganize button.
in the Sort section,
select the mode "Sort the Selected Range" (I'm not sure of the English wording)
choose Column A and Ascending.
It will sort every rows minus row 1.
Yvan KOENIG (VALLAURIS, France) lundi 29 août 2011 16:21:36
iMac 21”5, i7, 2.8 GHz, 4 Gbytes, 1 Tbytes, mac OS X 10.6.8 and 10.7.0
My iDisk is : <http://public.me.com/koenigyvan>
Please : Search for questions similar to your own before submitting them to the community
How do I reverse all columns and rows?
