I have a massive XLSX export file that contains thousands of trading transactions. Sometimes there are many rows that below to the SAME order.
I want to run a power query (or other) that will consolidate multiple rows into ONE row if the trade_done_at column is within 1 second. Since these have the same order_id these multiple rows would become ONE row. All other rows would remain untouched.
So, in the attached file, the first 3 rows would be grouped together due to the same order_id.
test-data.xlsx
Column deal_price would be an avg of the values.
Columns for amount, funds, fee would be sum of the values.
All others would just have the same value.
Using EXCEL for MAC - V 16.66.1
How can I do this in excel?
Bookmarks