Hi Guys,
I am normal excel user. Here i have requirement of converting data's from rows to columns i.e., i want to re-arrange data from line to column, but i have more then 20 lines so first line datas to be filed in column and second line data to be added in same column next to first line data.
How can i do that.
Here is what i have
HEAD1 DATA1 DATA2 DATA3 DATA4 DATA5
HEAD2 DATA10 DATA11 DATA12 DATA13 DATA14
HEAD3 DATA20 DATA21 DATA22 DATA23 DATA24
Here is what I want
HEAD1 DATA1
HEAD1 DATA2
HEAD1 DATA3
HEAD1 DATA4
HEAD1 DATA5
HEAD2 DATA10
HEAD2 DATA11
HEAD2 DATA12
HEAD2 DATA13
HEAD2 DATA14
HEAD3 DATA20
HEAD3 DATA21
HEAD3 DATA22
HEAD3 DATA23
HEAD3 DATA24
Thanks in advance.
Bookmarks