Question about Pivot

Hi,

Just quick question on Pivot, can MY_Model PIVOT functionality doing something like this or I need to use raw sql statement to achieve it?

Sample question from SO :

https://stackoverflow.com/questions/21118809/combine-multiple-rows-into-one-row-mysql

Thanks for the great library!