0

I have 85 large CSV files. Each contains rows with timestamps, a tag, and several values. I've created a Query for the folder containing these CSVs. I want to combine rows based on the timestamps so that there is a single row for each time and then additional columns that contain the tags and values. I can't bring everything back into excel since there are millions of rows. Is there a way to merge these?

Here are some example rows from the Query. I would want to combine the first 18 rows for example into a single row for 1/10/2016 12:00:00 AM.

enter image description here

RossV
  • 195
  • 3
  • 12
  • The solution can use something like the approaches mentioned in this question: https://stackoverflow.com/questions/44058355/powerquery-how-can-i-concatenate-grouped-values – Alejandro Lopez-Lago - MSFT Jun 15 '17 at 23:02
  • can you send the sample excel file with the cvs files ? (just a few rows of data will be enough) – Umut K Jun 16 '17 at 07:28
  • What do you mean "to combine"? You want to sum Values, for example? Or maybe you want to get value's average? And what to do with text strings like Tagname? Concatenate? – Sergey Lossev Jun 18 '17 at 22:46

0 Answers0