Hi
I have a dabatase with multiple mutations for a big number of patients (more than 1000). I wish to put on the same row the mutations for each patient. Is it possible to automate it?
Here an example of how is the db now
|ID Gene|
|1| KRAS|
|1| p53|
|1| STK11|
|2| EGFR|
|2| p53|
|3| STK11|
|3| KEAP1|
|3| p53|
And how I need to format
|ID| EGFR KRAS STK11 p53 Keap1
|1| 0 1 1 1 0
|2| 1 0 0 1 0
|3 0 0 1 1 1
I hope I described it clearly!
thank you to everyone can help me!!