PQ - Unpivot many rows to many columns

[Nirrobi]

Hi all,

I have table as the below:
ID Text
1 A
2 B
1 C
3 A
4 A
4 B

And I should to change it to this one with power query

ID Text1 Text2
1 A C
2 B
3 A
4 A B

Is it possible to achieve via PQ ?

Thanks in advanced,
Nir

 

[MarcelBeug]

This question is cross posted and answered here. Even with a explanatory video and 2 solutions.

Cross posting is a bad habit and even worse is not responding to the answers provided.

 

[Nirrobi]

Sorry,
Will learn for future.

thanks for your help!

Nir.