Split rows values into multiple columns

Hello,

I need to split "Group" into "Value1" and "Value2" from the table below:

The first 3 columns are identical, so I'd like to have a table like:

Column1 | Column2 | Column3 | A Value | B Value

I know I can create two references of this table, filter by "Group" and then merge them back together, but isn't there a better way?

Thanks for helping!