I have a gallery with Items like:
Distinct(
Source,
Title
)
and Label1 like:
ThisItem.Result
I would like to add another Label2 with text from another column B (based on a ThisItem.Result from Label1).
Title columns is not unique and ColumnB is not unique but there is always the same value for each row like below:
| Title | Column B |
| a | 111 |
| a | 111 |
| a | 111 |
| b | 222 |
| b | 222 |
| b | 222 |
| b | 222 |
| c | 333 |
| c | 333 |
| c | 333 |
| c | 333 |
| c | 333 |
| c | 333 |
| c | 333 |
| x | 888 |
| x | 888 |
| x | 888 |
| x | 888 |
So what I want to show is:
| Title | Column B |
| a | 111 |
| b | 222 |
| c | 333 |
| x | 888 |
How should I do this?
