Column of Unique Values for a report table

[Bagrat_Tsakadze]

Hi Community,

I am desperate to find a way to create a column with unique values per row. In other words, I need to transform multiple repetitive values from Table "A" to REPORT TABLE "B" with only one unique value per row. Each row in REPORT TABLE "B" has many columns for report data calculations. 

The same function is easily performed in Google Spreadsheet by an ARRAYFOMULA(Unique(COLUMN)). The formula just populates the target column with unique values only. 

Any help will be of great value to me.

Awaiting any hint with gratitude ))

[Tommy62]

UNIQUE(Tabelle[Spalte])

Gibt eine Liste der Spaltenwerte aus der Tabelle ohne Duplikate zurück.

Wenn ein PDF-Bericht erstellt wird, siehe dieses Erklärvideo: How To Build a Grouped PDF Template

[TeeSee1]

If you want to build a table with rows with unique values across multiple columns, then I find it easiest to create a VC whose value is a concatenation of the columns you want to check and make the column the key of the table. You can simply copy all the rows of the source table into this table and the system rejects any duplicate rows (first come first saved) automatically.