Csv import, multiple lines to single row in excel

1

I have a csv file that has a list of temperature readings from a sensor. The csv file has one line for each temperature recorded. Each line has timestamp and temperature.

I would like to import to excel but only want to start a new row if the date changes. For example, if I have 8 temperatures for 1/12/23 I want column 1 to be the date, the next 8 columns the temperatures. I will use time as a header for the columns as the 8 temperatures are at scheduled intervals. Sample from csv file pasted below.

“Timestamp”,“Temperature (°F)”
“2023-01-25 18:00”,“37.0300”
“2023-01-25 19:00”,“37.3000”
“2023-01-25 20:00”,“37.4000”
“2023-01-25 21:00”,“37.5500”
“2023-01-25 22:00”,“37.1100”
“2023-01-25 23:00”,“37.2300”
“2023-01-26 00:00”,“37.2100”
“2023-01-26 01:00”,“37.1300”
“2023-01-26 02:00”,“37.1700”
“2023-01-26 03:00”,“37.1900”
“2023-01-26 04:00”,“37.3000”
“2023-01-26 05:00”,“37.3000”
“2023-01-26 06:00”,“37.5000”
“2023-01-26 07:00”,“37.3600”

This is probably easy but I need help please.

Thanks.

2

Greetings,

just a few seconds

  • split the date in 2 parts : date and time
  • suppress the timestamp column
  • pivot
    Done, 20 sec…

Regards

convert.morph (4.9 KB)
new 5.csv (510 Bytes)

1 Like
3

Thank you so much. This is exactly what I needed.

4

May I suggest you to convert the date in date format instead of keeping a text format as I did.