sorting rows

hdg — Fri, 16 May 2014 16:53:53 GMT

Hello everyone,

I have the following dataset

I would like to sort the rows based on max date in the above table and the name = active. In this case all rows will be sorted based on row 4:

for example the resulting data set looks like below.

This is just a small example of 3 columns but I could have more.

Any help is appreciated many Thanks!

Re: sorting rows

ballardw — Fri, 16 May 2014 16:59:36 GMT

Doesn't look like a sort at this point just a column reorder. There are several threads in the forum about reordering data columns in a data set.