# Help with MySQL to Transpose a Table

**URL:** <https://forum.kirupa.com/t/help-with-mysql-to-transpose-a-table/285315>\
**Category:** programming\
**Created:** [March 30, 2009, 1:38pm UTC](https://forum.kirupa.com/t/help-with-mysql-to-transpose-a-table/285315 "2009-03-30T13:38:53Z")\
**Posts on this page:** 1\
**Page:** 1

<div class="post-metadata">

**Author:** ![Vova1981](https://avatars.discourse-cdn.com/v4/letter/v/4da419/32.png) [@Vova1981](https://forum.kirupa.com/u/Vova1981)\
**Post date:** [March 30, 2009, 1:38pm UTC](https://forum.kirupa.com/t/help-with-mysql-to-transpose-a-table/285315/1 "2009-03-30T13:38:53Z")

</div>

Hi,

I have a MySql Table which looks like this

Evaluator\_ID Evaluator\_Name  
1 Manku  
2 Jenny  
3 Evaluator  
4 Ian  
99 test1

I need to transpose this tabe to look like this:

Manku Jenny Evaluator Ian Test1  
1 2 3 4 99

Please help.