Csv import, multiple lines to single row in excel

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.



just a few seconds

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


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

1 Like

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

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