Excel Tips No 29 : Transpose Data in Same Row to be in Same Column - Methode II

This free microsoft excel tips no 29 is telling how to ranspose data in a same row to be filled in a samecoloumn, or vise versa - second methode. Previously, I have told another way here : http://free-excel-tips.blogspot.com/2009/06/excel-tips-no-6-transpose-data-in-same_5928.html. Now, Iwill tell you another simple way to do This :



1. Block B2 - F2
2. Right click and select copy, or press Ctrl + C
3. Click destination cell, ie : Cell H3
4. Right click and select paste special
5. Select transpose option
6. Select "OK"

May this tips can be usefull for you