Hi all

need an urgent help

i have excel sheet which contains

sapid 1 2 3 4 5 6
10000001 g g g g off m
10000002 m m m off g g
10000003 m1 m1 off g g g
10000004 m2 off m1 m1 m1 m1

sapid , 1 ,2 ,3... these are the colomn names
but i want in following format

sapid 1 2 3 4
10000001 g g g g
10000001 off m
10000002 m m m off
10000002 g g
10000003 m1 m1 off g
10000003 g g
10000004 m2 off m1 m1
10000004 m1 m1


i hope u understand

regards
killerware