Sorting random Data

Hi,

I extract some data from a device in excel and the data is not sorted in a logical way. Below is an example of data i get:


Date Time CODE Input val Output val Errors lockouts CODE2
02/09/2014 11:09:02 BA 257.3 230.2 0 0 CC


The information is always in this sequence and multiple pages of data is acquired. However the data itself is as following:


09/09/2014 7:42:06 FA 225.8 230.4 15 0 0 -+ 09/09/2014 7:42:06 BA 227.3 227.1 14 0 0 -+ 09/09/2014 7:42:22 FA
227.7 232.4 14 0 0 -+ 09/09/2014 7:42:22 BA 229.7 229.7 13 0 0 -+ 09/09/2014 7:42:46 FA 228.3 233.8 8 0 0 -+ 09/09/2014 7:42:46 BA ....CONTINUED


I would like to sort the data above as following:
09/09/2014 7:42:06 FA 225.8 230.4 15 0 0 -+
09/09/2014 7:42:06 BA 227.3 227.1 14 0 0 -+
09/09/2014 7:42:22 FA 227.7 232.4 14 0 0 -+
09/09/2014 7:42:22 BA 229.7 229.7 13 0 0 -+
09/09/2014 7:42:46 FA 228.3 233.8 8 0 0 -+ ... and so on


What is the quickest way to do this. Manual sorting is not an option as i can have thousands of rows of data above.

Thank you.

Originally Posted by mahmoodadeel

Hi,

I extract some data from a device in excel and the data is not sorted in a logical way. Below is an example of data i get:


Date Time CODE Input val Output val Errors lockouts CODE2
02/09/2014 11:09:02 BA 257.3 230.2 0 0 CC


The information is always in this sequence and multiple pages of data is acquired. However the data itself is as following:


09/09/2014 7:42:06 FA 225.8 230.4 15 0 0 -+ 09/09/2014 7:42:06 BA 227.3 227.1 14 0 0 -+ 09/09/2014 7:42:22 FA
227.7 232.4 14 0 0 -+ 09/09/2014 7:42:22 BA 229.7 229.7 13 0 0 -+ 09/09/2014 7:42:46 FA 228.3 233.8 8 0 0 -+ 09/09/2014 7:42:46 BA ....CONTINUED


I would like to sort the data above as following:
09/09/2014 7:42:06 FA 225.8 230.4 15 0 0 -+
09/09/2014 7:42:06 BA 227.3 227.1 14 0 0 -+
09/09/2014 7:42:22 FA 227.7 232.4 14 0 0 -+
09/09/2014 7:42:22 BA 229.7 229.7 13 0 0 -+
09/09/2014 7:42:46 FA 228.3 233.8 8 0 0 -+ ... and so on


What is the quickest way to do this. Manual sorting is not an option as i can have thousands of rows of data above.

Thank you.

mahmood,

The attached example workbook works for some of the example data you posted; at least how I interpreted it. However, for one of your examples - specifically the last one - the formula won't work because the value 8 is different than the other two digit values in the previous examples. If you only have single and two digit data sets, you can modify the formula as needed to work.

Let me know if you have any questions.