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
Bookmarks