Pull multiple columns from one row, for multiple rows

[Marvin-JR]

Hello,

I'm attempting to pull two columns from a single row and show them together. I also need to repeat this for any additional rows with the same ID. In the below screenshot, I have "Unique ID" set to copy to a different table to a column labeled "Merch UUID" on an action.

This "Unique ID" is how I'll match up the data. The columns I'd like to pull down, and most importantly keep these two columns associated, are "Date" and "Note". See below screenshot.

I was able to pull the data, but it is NOT associated with any particular row like I need it to be. See below.

This is how I got the above result. 

CONCATENATE(SELECT(Receipt date[Date], ([Merch UUID] = [_THISROW].[Unique ID]))," ",
SELECT(Receipt date[NOTE], ([Merch UUID] = [_THISROW].[Unique ID])))

Any help will be greatly appreciated.

[AleksiAlkio]

What the result should look like when it's correct?

[Marvin-JR]

Data should be like this.

• Date A - Note A
• Date B - Note B

Since I will be combining  multiple rows, I don't know how to keep those same-row records joined to each other. If there is a totally different way to do this, I'd be happy to learn it. 

[syedfaheemuddin · Accepted solution]

You can add a new (virtual) column in the table "Receipt date" with formula

CONCATENATE([Date]," - ",[NOTE])

Then Select statement in the other table 

[Marvin-JR]

Works perfectly. Thank you!