hide column with null values

[Giada90]

Hi,

I have a situation like this:

client	score
a	4,5,6
b	2
c	2,1

I can split and have a situation like this:

client	score.1	score.2	score.3
a	4	5	6
b	2
c	2	1

[amitchandak · Accepted solution]

@Giada90 , You can split by delimiter in Power query

Power Query Split Column , Split Column By Delimiter: https://youtu.be/FyO9Vmhcfag