Custom Column

[Syndicate_Admin]

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.

[Syndicate_Admin]

Thank you a lot, it was way easier than what I was trying! I really appreciate it

[BA_Pete]

No problem, happy to help.

Feel free to give a thumbs-up and accept the answer as the solution 👍

Pete

[BA_Pete · Accepted solution]

Hi,

You can add a new custom column like this:

if Text.Contains([Entity], "-") then [Entity] else null

Then select your new column and go to the Transform tab > Fill (dropdown) > Down.

Then filter your [Entity] column on Does Not Contain "-".

Pete