Power Platform Community Forum Thread Details

Hello everyone!

I got stuck with a data set I'm working right now, and i will appreciate any help I can get.

In my first column i have different ID numbers. The ID number appears first, and right bellow it all the transactions that were associated with that ID number, then the next ID number comes up, and again all the transactions associated with it.

For a better analysis, I am trying to create a custom column that has the ID number right beside the transaction, but I am failing to do so, as can be seen in the attachment.

Is it possible to do that using Power Query? I will appreciate any help I can get.

Thank you in advance for your comments.