Create a new table from columns from an existing table with unique values

[Mark88]

I'm trying to create a new table from an existing table called Samples. The Sample_Id is occuring multiple times in the table, but only a couple of times a value is connected to a sample ID. What I want is to create a table with all sample ID's occuring only once and the sample ID's with a value connected to them should show the value. See an example of the database below:

Sample_Id	Value
13
13
13
24
24	0,76
24
32
32
42
42	0,45
42

The result I want to get is:

Sample_Id	Value
13
24	0,76
32
42	0,45

Can anyone please advise how I can do this? Thanks in advance for your help!

[Zubair_Muhammad · Accepted solution]

@Mark88 

As a calculated table you can use

Table = SUMMARIZE(Table1,Table1[Sample_Id],"Value",sum(Table1[Value]))

[Mark88]

Many thanks @Zubair_Muhammad !!