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

Question

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 [e-mail] 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>