Forum Discussion
How to pivot
Hi I'm new to power query, and I have a dataset where I have 2 columns I want to pivot and align. tracking_number shipment_reference carrier_name sender_country_code recipient_postal...
Hi Bob
It wont really, unfurnenately 😕
I have a dataset like this:
And I would like it to only be 1 line pr shipment id, with the 1. event_Date_time for each operationnal status:
I see what you mean. Based on the data set you have its possible to get it down just to 1 line per shipment_id and filter to the latest status change using the data and time field you have, but you are looking to transpose the data....thats a little more tricky.
That said, Transpose might be the key word your looking for! try googling how to transpose a data set or column in power bi see if the brings anything up
i dont think this link is exactly what you need but i think its heading towards the right direction.
Good Luck!
