Split rows values into multiple columns

[webportal]

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!

[Vvelarde · Accepted solution]

@webportal

Hi, Lets try with this:

Regards

Victor

[webportal]

He He, I knew it had to be easy...
Thank you!