zephyr2009
New Member
- Joined
- Jun 2, 2013
- Messages
- 1
I have here a .csv file containing dates and time with an interval of 15 minutes and have a value.
how can I sort these data where row can be set the date and time can be set as column... Thank you.
<colgroup><col><col></colgroup><tbody>
</tbody>
how can I sort these data where row can be set the date and time can be set as column... Thank you.
Time | Pressure |
01/01/2014 | |
1/1/14 0:00 | 103.66 |
1/1/14 0:15 | 97.98 |
1/1/14 0:30 | 97.27 |
1/1/14 0:45 | 96.56 |
1/1/14 1:00 | 90.17 |
1/1/14 1:15 | 99.4 |
1/1/14 1:30 | 101.53 |
1/1/14 1:45 | 104.37 |
1/1/14 2:00 | 103.66 |
1/1/14 2:15 | 106.5 |
1/1/14 2:30 | 107.92 |
1/1/14 2:45 | 109.34 |
1/1/14 3:00 | 107.92 |
1/1/14 3:15 | 110.05 |
1/1/14 3:30 | 110.05 |
1/1/14 3:45 | 110.05 |
1/1/14 4:00 | 109.34 |
1/1/14 4:15 | 107.92 |
1/1/14 4:30 | 115.02 |
1/1/14 4:45 | 115.73 |
1/1/14 5:00 | 116.44 |
1/1/14 5:15 | 115.02 |
1/1/14 5:30 | 116.44 |
1/1/14 5:45 | 115.02 |
1/1/14 6:00 | 112.89 |
1/1/14 6:15 | 111.47 |
1/1/14 6:30 | 107.92 |
1/1/14 6:45 | 98.69 |
1/1/14 7:00 | 96.56 |
1/1/14 7:15 | 97.27 |
1/1/14 7:30 | 90.17 |
1/1/14 7:45 | 95.85 |
1/1/14 8:00 | 80.94 |
1/1/14 8:15 | 82.36 |
1/1/14 8:30 | 79.52 |
1/1/14 8:45 | 80.94 |
1/1/14 9:00 | 81.65 |
1/1/14 9:15 | 76.68 |
1/1/14 9:30 | 69.58 |
1/1/14 9:45 | 68.16 |
1/1/14 10:00 | 56.8 |
1/1/14 10:15 | 65.32 |
1/1/14 10:30 | 66.74 |
1/1/14 10:45 | 68.16 |
1/1/14 11:00 | 66.74 |
1/1/14 11:15 | 75.26 |
1/1/14 11:30 | 69.58 |
1/1/14 11:45 | 66.74 |
1/1/14 12:00 | 66.03 |
1/1/14 12:15 | 72.42 |
1/1/14 12:30 | 74.55 |
1/1/14 12:45 | 73.84 |
1/1/14 13:00 | 68.16 |
1/1/14 13:15 | 68.87 |
1/1/14 13:30 | 71.71 |
1/1/14 13:45 | 74.55 |
1/1/14 14:00 | 78.81 |
1/1/14 14:15 | 80.23 |
1/1/14 14:30 | 75.97 |
1/1/14 14:45 | 85.91 |
1/1/14 15:00 | 84.49 |
1/1/14 15:15 | 85.2 |
1/1/14 15:30 | 87.33 |
1/1/14 15:45 | 81.65 |
1/1/14 16:00 | 76.68 |
1/1/14 16:15 | 74.55 |
1/1/14 16:30 | 71.71 |
1/1/14 16:45 | 79.52 |
1/1/14 17:00 | 71 |
1/1/14 17:15 | 70.29 |
1/1/14 17:30 | 66.74 |
1/1/14 17:45 | 71.71 |
1/1/14 18:00 | 73.13 |
1/1/14 18:15 | 74.55 |
1/1/14 18:30 | 80.23 |
1/1/14 18:45 | 79.52 |
1/1/14 19:00 | 76.68 |
1/1/14 19:15 | 76.68 |
1/1/14 19:30 | 80.23 |
1/1/14 19:45 | 86.62 |
1/1/14 20:00 | 93.72 |
1/1/14 20:15 | 93.01 |
1/1/14 20:30 | 89.46 |
1/1/14 20:45 | 94.43 |
1/1/14 21:00 | 94.43 |
1/1/14 21:15 | 99.4 |
1/1/14 21:30 | 92.3 |
1/1/14 21:45 | 93.72 |
1/1/14 22:00 | 94.43 |
1/1/14 22:15 | 100.82 |
1/1/14 22:30 | 101.53 |
1/1/14 22:45 | 104.37 |
1/1/14 23:00 | 106.5 |
1/1/14 23:15 | 105.08 |
1/1/14 23:30 | 109.34 |
1/1/14 23:45 | 109.34 |
1/2/14 0:00 | 108.63 |
1/2/14 0:15 | 109.34 |
1/2/14 0:30 | 109.34 |
1/2/14 0:45 | 111.47 |
1/2/14 1:00 | 112.18 |
1/2/14 1:15 | 110.76 |
1/2/14 1:30 | 111.47 |
1/2/14 1:45 | 112.18 |
1/2/14 2:00 | 112.18 |
1/2/14 2:15 | 112.18 |
1/2/14 2:30 | 110.76 |
1/2/14 2:45 | 112.18 |
1/2/14 3:00 | 110.76 |
1/2/14 3:15 | 110.05 |
1/2/14 3:30 | 109.34 |
1/2/14 3:45 | 110.05 |
1/2/14 4:00 | 110.05 |
1/2/14 4:15 | 109.34 |
1/2/14 4:30 | 114.31 |
1/2/14 4:45 | 111.47 |
1/2/14 5:00 | 112.18 |
1/2/14 5:15 | 110.05 |
1/2/14 5:30 | 105.79 |
1/2/14 5:45 | 109.34 |
1/2/14 6:00 | 93.01 |
1/2/14 6:15 | 99.4 |
1/2/14 6:30 | 85.2 |
1/2/14 6:45 | 85.2 |
1/2/14 7:00 | 73.84 |
1/2/14 7:15 | 68.87 |
1/2/14 7:30 | 68.87 |
1/2/14 7:45 | 71 |
1/2/14 8:00 | 66.74 |
1/2/14 8:15 | 67.45 |
1/2/14 8:30 | 65.32 |
1/2/14 8:45 | 68.87 |
1/2/14 9:00 | 59.64 |
1/2/14 9:15 | 53.96 |
1/2/14 9:30 | 57.51 |
1/2/14 9:45 | 48.28 |
1/2/14 10:00 | 51.12 |
1/2/14 10:15 | 49.7 |
1/2/14 10:30 | 51.12 |
1/2/14 10:45 | 50.41 |
1/2/14 11:00 | 51.12 |
1/2/14 11:15 | 51.12 |
1/2/14 11:30 | 53.25 |
1/2/14 11:45 | 59.64 |
1/2/14 12:00 | 55.38 |
1/2/14 12:15 | 56.09 |
1/2/14 12:30 | 56.09 |
1/2/14 12:45 | 59.64 |
1/2/14 13:00 | 65.32 |
1/2/14 13:15 | 63.19 |
1/2/14 13:30 | 75.97 |
1/2/14 13:45 | 75.97 |
1/2/14 14:00 | 74.55 |
1/2/14 14:15 | 79.52 |
1/2/14 14:30 | 80.94 |
1/2/14 14:45 | 75.26 |
1/2/14 15:00 | 71 |
1/2/14 15:15 | 71 |
1/2/14 15:30 | 70.29 |
1/2/14 15:45 | 73.84 |
1/2/14 16:00 | 63.9 |
1/2/14 16:15 | 70.29 |
1/2/14 16:30 | 70.29 |
1/2/14 16:45 | 79.52 |
1/2/14 17:00 | 82.36 |
1/2/14 17:15 | 71.71 |
1/2/14 17:30 | 70.29 |
1/2/14 17:45 | 63.19 |
1/2/14 18:00 | 70.29 |
1/2/14 18:15 | 69.58 |
1/2/14 18:30 | 75.97 |
1/2/14 18:45 | 74.55 |
1/2/14 19:00 | 81.65 |
1/2/14 19:15 | 81.65 |
1/2/14 19:30 | 81.65 |
1/2/14 19:45 | 75.26 |
1/2/14 20:00 | 79.52 |
1/2/14 20:15 | 90.88 |
1/2/14 20:30 | 97.27 |
1/2/14 20:45 | 95.14 |
1/2/14 21:00 | 95.85 |
1/2/14 21:15 | 96.56 |
1/2/14 21:30 | 95.85 |
1/2/14 21:45 | 97.98 |
1/2/14 22:00 | 95.14 |
1/2/14 22:15 | 97.27 |
1/2/14 22:30 | 92.3 |
1/2/14 22:45 | 98.69 |
1/2/14 23:00 | 105.08 |
1/2/14 23:15 | 105.79 |
1/2/14 23:30 | 111.47 |
1/2/14 23:45 | 110.05 |
1/3/14 0:00 | 106.5 |
1/3/14 0:15 | 110.76 |
1/3/14 0:30 | 112.18 |
1/3/14 0:45 | 111.47 |
1/3/14 1:00 | 112.18 |
1/3/14 1:15 | 112.18 |
1/3/14 1:30 | 115.73 |
1/3/14 1:45 | 115.02 |
1/3/14 2:00 | 116.44 |
1/3/14 2:15 | 115.73 |
1/3/14 2:30 | 115.73 |
1/3/14 2:45 | 116.44 |
1/3/14 3:00 | 113.6 |
1/3/14 3:15 | 115.73 |
1/3/14 3:30 | 115.02 |
1/3/14 3:45 | 112.18 |
1/3/14 4:00 | 112.89 |
1/3/14 4:15 | 111.47 |
1/3/14 4:30 | 117.15 |
1/3/14 4:45 | 113.6 |
1/3/14 5:00 | 115.02 |
1/3/14 5:15 | 112.89 |
1/3/14 5:30 | 112.89 |
1/3/14 5:45 | 110.05 |
1/3/14 6:00 | 108.63 |
1/3/14 6:15 | 102.95 |
1/3/14 6:30 | 92.3 |
1/3/14 6:45 | 77.39 |
1/3/14 7:00 | 73.13 |
1/3/14 7:15 | 74.55 |
1/3/14 7:30 | 74.55 |
1/3/14 7:45 | 72.42 |
1/3/14 8:00 | 69.58 |
1/3/14 8:15 | 61.06 |
1/3/14 8:30 | 61.06 |
1/3/14 8:45 | 56.8 |
1/3/14 9:00 | 56.8 |
1/3/14 9:15 | 61.77 |
1/3/14 9:30 | 63.9 |
1/3/14 9:45 | 61.06 |
1/3/14 10:00 | 53.25 |
1/3/14 10:15 | 63.19 |
1/3/14 10:30 | 63.9 |
1/3/14 10:45 | 63.19 |
1/3/14 11:00 | 66.74 |
1/3/14 11:15 | 68.87 |
1/3/14 11:30 | 61.06 |
1/3/14 11:45 | 63.19 |
1/3/14 12:00 | 62.48 |
1/3/14 12:15 | 71.71 |
1/3/14 12:30 | 64.61 |
1/3/14 12:45 | 64.61 |
1/3/14 13:00 | 67.45 |
1/3/14 13:15 | 63.9 |
1/3/14 13:30 | 74.55 |
1/3/14 13:45 | 64.61 |
1/3/14 14:00 | 63.19 |
1/3/14 14:15 | 71.71 |
1/3/14 14:30 | 73.84 |
1/3/14 14:45 | 80.94 |
1/3/14 15:00 | 78.81 |
1/3/14 15:15 | 79.52 |
1/3/14 15:30 | 79.52 |
1/3/14 15:45 | 80.23 |
1/3/14 16:00 | 75.26 |
1/3/14 16:15 | 78.1 |
1/3/14 16:30 | 83.07 |
1/3/14 16:45 | 83.07 |
1/3/14 17:00 | 75.26 |
1/3/14 17:15 | 75.26 |
1/3/14 17:30 | 65.32 |
1/3/14 17:45 | 71 |
1/3/14 18:00 | 70.29 |
1/3/14 18:15 | 78.1 |
1/3/14 18:30 | 75.26 |
1/3/14 18:45 | 73.13 |
1/3/14 19:00 | 79.52 |
1/3/14 19:15 | 86.62 |
1/3/14 19:30 | 88.75 |
1/3/14 19:45 | 90.88 |
1/3/14 20:00 | 84.49 |
1/3/14 20:15 | 85.2 |
1/3/14 20:30 | 94.43 |
1/3/14 20:45 | 95.14 |
1/3/14 21:00 | 102.24 |
1/3/14 21:15 | 98.69 |
1/3/14 21:30 | 100.82 |
1/3/14 21:45 | 97.27 |
1/3/14 22:00 | 102.24 |
1/3/14 22:15 | 104.37 |
1/3/14 22:30 | 105.79 |
1/3/14 22:45 | 100.82 |
1/3/14 23:00 | 106.5 |
1/3/14 23:15 | 105.08 |
1/3/14 23:30 | 105.79 |
1/3/14 23:45 | 105.79 |
<colgroup><col><col></colgroup><tbody>
</tbody>