Combine data from multiple columns

 Hi, KristinG 

Thanks for the ideas provided by DataZoe , I tried to make some changes to the formula

Table2 =
SUMMARIZE (
    UNION (
        SELECTCOLUMNS (
            'Table',
            "Product", 'Table'[Product ID],
            "Name", 'Table'[Name],
            "Currency", 'Table'[Currency 1],
            "Value", 'Table'[Material value 1]
        ),
        SELECTCOLUMNS (
            'Table',
            "Product", 'Table'[Product ID],
            "Name", 'Table'[Name],
            "Currency", 'Table'[Currency 2],
            "Value", 'Table'[Material value 2]
        ),
        SELECTCOLUMNS (
            'Table',
            "Product", 'Table'[Product ID],
            "Name", 'Table'[Name],
            "Currency", 'Table'[Currency 3],
            "Value", 'Table'[Material value 3]
        )
    ),
    [Currency],
    [Value]
)

Result:

Table2:

Visual:

Please refer to the attachment below for details

Best Regards,
Community Support Team _ Zeon Zheng
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.