如何将用户的帖子从行转换为列？ [重复]

This question already has an answer here:

MySQL pivot table 8 answers
pivot html table using php 1 answer
Converting rows records to columns in mySQL 1 answer

I want all the activities submitted by user sarang@gmail.com in to a single row in short i want to create columns while user posts any activity (in php & mysql).

Here is the situation

</div>