How to set the .csv file to column and row

[zephyr2009]

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.

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>

 

[dermie_72]

insert a column to the left of pressure, then use text to column (space as the delimeter), which should split the column into dates and times.