This appears to be a simple problem that I am unable to solve. I have some data that looks like this:
CHROM POS REF ALT TYPE AF chr1 1 A T MISSENSE 0.23 chr2 1 A T,G MISSENSE 0.17, 0.09
The above is dummy meaningless data, but it is representative of the problem at hand.
I'd like to
separate_rows such that the
AF are separated in a couples manner. Running
separate_rows on the 2 columns would give me 4 rows, not 2. I'd like my output to be:
CHROM POS REF ALT TYPE AF chr1 1 A T MISSENSE 0.23 chr2 1 A T MISSENSE 0.17 chr2 1 A G MISSENSE 0.09
Is there any way I can conserve this combination while separating the values out? I am really far out from the VCF to go back and split multi-allelics.