Hi guz I want to merge multiple rows into a multiple columns based on the first column.
The file has symbol //
I want to break the symbool // and I nedd exactlynew column at that point
the output will be like this
please guyz help in this isssue!!!!!
merging rows into columns FIle1
a 1
b 2
c 3
d 4
//
a 9
b 44
//
c 5
d 8
c 4
d 0
Output
a b c d
1 2 3 4
9 44 5 8
4 0
Add a new column where // is? Your output doesn't show that is what you want.. Could you please give a better example, something that is logical?
I have a file with 2 columns. evry set in a column ends with a symbol //.
the first one with something like chr, chr no, chromosome name, cell no. cell no. etc and the second column has values belong to the first columnlike chr Xy, 22, 345,22222 etc. Some clumns have repeated but not duplicate values. with these I want to make file with first cloumn as first row and second olumn as second row and so on...
chr chrXY
chr no 22
chrname FUUR
Cell 224Neuron
Cell no 22222
//
chr chrYY
chr no 23
chrname FUUS
Cell 225Neuron
Cell no 22223
//
chr chrYY
chr no 24
chrname FUUT
Cell 226Neuron
Cell no 22222
Cell 227Neuron
Cell no 222245
Cell 230Neuron
Cell no 22245
//
chr chrYY
chr no 25
chrname RUUS
Cell 225Neuron
Cell no 52223
chr chr no chrname Cell Cell no
chrXY 22 FUUR 224Neuron 22222
chrYY 23 FUUS 225Neuron 22223
chrYY 24 FUUT 226Neuron 222222
227Neuron 222245
230Neuron 22245
chrYY 25 RUUS 225Neuron 52223
227Neuron 222245
230Neuron 22245 will be in their successive related column.
some font error is preveting the alignment
Output
chr .........chr no....... chrname ......Cell............. Cell no
chrXY....... 22 ............FUUR .........224Neuron..... 22222
chrYY .......23 .............FUUS .........225Neuron .....22223
chrYY....... 24 .............FUUT.......... 226Neuron.... 222222
...................................................227Neuron.... 222245
..................................................230Neuron ......22245
chrYY .......25............. RUUS ..........225Neuron ......52223