Notifications
Clear all
Power Query
3
Posts
2
Users
0
Reactions
82
Views
Topic starter
Hello,
I have a transaction log where I want to combine the rows who have the same ID and Time stamp. In the attached file a have put an example.
Is this possible in a query?
Please advise.
Kind regards.
Meine
Posted : 30/06/2022 12:20 pm
Please see attached. Once you have connected to the table and set the correct data type to Time for the time column, you can group by ID and Time. Please refer to the attached file.
Note: The query in the attached file was made with PQ for the Mac. A little bit different than the PC version, but very similar.
Posted : 30/06/2022 3:11 pm
Topic starter
Thx Riny,
It works fine.
Meine
Posted : 30/06/2022 5:24 pm
