something_like_transpose
 

how easily convert the follow situation

date1 date2 date3 datex
name1 a1 a2 a3 a4
name2 b1 b2 b3 b4
name3 c1 c2 c3 c4


namen d1 d2 d3 d4

to this

date1 name1 a1
date2 name1 a2
date3 name1 a3
datex name1 a4
date1 name1 b1
date2 name2 b2
date3 name2 b3
datex name2 b4
date1 namen c1
date2 namen c2
date3 namen c3
datex namen c4
date1 namen d1
date2 namen d2
date3 namen d3
datex namen d4



thank you

something_like_transpose
 

Hi
have a look at
http://j-walk.com/ss/excel/usertips/tip068.htm

Frank

gbelo wrote:
how easily convert the follow situation

date1 date2 date3 datex
name1 a1 a2 a3 a4
name2 b1 b2 b3 b4
name3 c1 c2 c3 c4


namen d1 d2 d3 d4

to this

date1 name1 a1
date2 name1 a2
date3 name1 a3
datex name1 a4
date1 name1 b1
date2 name2 b2
date3 name2 b3
datex name2 b4
date1 namen c1
date2 namen c2
date3 namen c3
datex namen c4
date1 namen d1
date2 namen d2
date3 namen d3
datex namen d4



thank you