I want to add respective column for repeat item on $1. If there is no repeat sequence on $1, I want the exact count in each col. Please would you help me guys!
----------------------------------------------------------
data
Name a b c d e f g h
GGGACGG 2 0 7 10 2 0 4 0
GGGAGGG 0 0 4 26 8 3 0 0
GGGAGGG 61 0 51 50 79 0 55 25
GGGAGTA 0 0 2 6 11 0 0 0
Result
Name a b c d e f g h
GGGACGG 2 0 7 10 2 0 4 0
GGGAGGG 61 0 55 76 87 3 55 25
GGGAGTA 0 0 2 6 11 0 0 0
----------------------------------------------------------
data
Name a b c d e f g h
GGGACGG 2 0 7 10 2 0 4 0
GGGAGGG 0 0 4 26 8 3 0 0
GGGAGGG 61 0 51 50 79 0 55 25
GGGAGTA 0 0 2 6 11 0 0 0
Result
Name a b c d e f g h
GGGACGG 2 0 7 10 2 0 4 0
GGGAGGG 61 0 55 76 87 3 55 25
GGGAGTA 0 0 2 6 11 0 0 0