How to rank data

Easy Data Transform can rank your data using the Sort transform.

rank data example

For example, to rank teams by points and then goals scored:

rank by mutliple columns

Various types of ranking are available:

For example using dense rank:

dense rank example

Partitioned ranking is available. For example, to use a separate ranking for each ‘Region’:

partitioned ranking

See the video above for more details.

Easy Data Transform can also help with merging, cleaning, filtering, enriching and reshaping your data. All without coding.

Try it free now!

Windows Logo Windows Download

v1.46.5 for Windows 11 / 10 / 8 / 7 (47 MB)
Zip file version

Apple Logo Mac Download

v1.46.5 for Mac 14.x to 10.13 (79 MB)

No commitments.
You can uninstall any time.
You don't even have to give us your email address.

Questions or problems?