Sort data in Access

[Juolupuki]

Hello,

Looking for solution or any suggestions, please. Having trouble to sort data in the why i need to.

In attached file "Unsorted" tab data need to be added in to MS Access table.
Second tab "Sorted" the why i need to be sorted.

The actual file is with over 600 rows, so manual to do is not really an option

 

[Gasman]

Use a query to present the data in the order required.

 

[isladogs]

Access tables have no inherent sort order.
Queries are used to sort the data into an desired order
Therefore it doesn't really matter how you import the data - unsorted or sorted.

 

[Juolupuki]

Power Query in excel did the trick really good tool for sorting data.

 

[isladogs]

Glad you got it sorted.
Excel PowerQuery is indeed an excellent tool but really wasn't needed in this case. Access queries are perfect for sorting data

 

[Juolupuki]

Glad you got it sorted.
Excel PowerQuery is indeed an excellent tool but really wasn't needed in this case. Access queries are perfect for sorting data

Well for today was quicker to do Unpivot Columns in PowerQuery and sort that why . In the future will try in Access.

 

[Pat Hartman]

Sorting the data in the spreadsheet may seem like it solved the problem but it didn't. As Ridders already told you, in a relational database, tables and queries have no inherent order. Access tends to fool you because when you open a table in DS view, it looks like it is sorted in PK order. However, once you add more records and change existing records, you will see that behavior no longer can be relied on.

The ONLY way to ensure data is sorted as you need it to be is to use a query with an Order By clause. Period!