OK so I messed up because I should of sorted the part numbers first then add the description. But anyway I have 4 columns with titles P/N’s, Description, Price and Quantity pack. I try to sort them but they all get sorted and the all 4 of them get mixed up. Is there a formula I can do to keep each row’s content correct? Here is an example http://screencast.com/t/vBiBTW24
I assume it is this:
Many records identified by part number and containing description, price and pk size as further fields
Are to be sorted by the part number as sorting key?
Select all your data rows and all the columns containing data AT A TIME.
Then use Menue: 'Data > ‘Sort …’
Choose Column A ‘Ascending’ and nothing else
Click OK