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.
Thank you a lot, it was way easier than what I was trying! I really appreciate it
mmbr1606
9
Super User 2025 Season 1
stampcoin
7
SD-13050734-0
6