Morning,
I have a file in the following format:
Serial number | Date/Time | Data
123 01/08/2017 00:30 3.2
123 01/08/2017 01:00 2.5
123 01/08/2017 01:30 3.1
456 01/08/2017 00:30 6
456 01/08/2017 01:00 6.5
I have data for each half hour of every day in a set period so the file is over a millions rows.
I would like the data in the following format:
Serial number | Date | 00:30 | 01:00 | 01:30
123 01/08/2017 3.2 2.5 3.1
123 02/08/2017 etc etc
123 03/08/2017
IS there a formula that can be used to do this?
Thank you
I have a file in the following format:
Serial number | Date/Time | Data
123 01/08/2017 00:30 3.2
123 01/08/2017 01:00 2.5
123 01/08/2017 01:30 3.1
456 01/08/2017 00:30 6
456 01/08/2017 01:00 6.5
I have data for each half hour of every day in a set period so the file is over a millions rows.
I would like the data in the following format:
Serial number | Date | 00:30 | 01:00 | 01:30
123 01/08/2017 3.2 2.5 3.1
123 02/08/2017 etc etc
123 03/08/2017
IS there a formula that can be used to do this?
Thank you