best practice for grouping based on csv meta tags

[renowijoyo]

I have this column with csv data. what i want is to do group analytical based on the values inside the strings. what is the best approach to do this? what i have in mind is not to split column but to have each of the original row being multiplied into several rows that contain one tag each.

so for example from the screencap above if lets say the 1st row would have been 'transformed' (is that the right term?) into 2 rows with row 1 has the 'smaxiiipa' tag, and row 2 has the 'biologi' tag.

if this approach is sensible, can someone point me out how to do just that? I m just beginning to use power BI.

Thanks,

[v-yuezhe-msft]

Hi @renowijoyo,

I am not quite clear that what is your expected result. Please follow the steps below to transpose or unpivot your columns, then check if figure 1 or figure 2 returns your desired result.

Process 1 : Split column and then transpose column.

1. In Query Editor of Power BI Desktop, split your current column into multiple columns by clicking Split Column->By Delimiter under Transform ribbon.

2. Remove blank columns by clicking Remove Columns->Remove Columns under Home ribbon.

3. Select all columns and then click Transpose under Transform ribbon.

Process 2: Split column and then unpivot columns

1. Same as step 1 of Process 1.
2. Same as step 2 of Process 2.
3. Select all columns and then click Unpivot Columns under Transform ribbon.

Thanks,
Lydia Zhang