Transform dataset issues

[Anonymous]

Hi, I have this table.

What I want is to transform it like picture below. So a record for every 'Loc' and each linked 'SearchCode'. I tried it with a Split By Delimiter, followed by grouping and/or (un)pivoting etc, but found no solution yet. Can this be done in power query?

KR

Wannes

[Arul]

@Anonymous ,

Select Searchcode column and use split by delimiter but select Rows in advanced options instead of columns.

Thanks,

Arul

[Anonymous · Accepted solution]

I've found the solution: Split column by delimiter can also done to rows. So simple...