Spreadsheet formatting [on hold] The 2019 Stack Overflow Developer Survey Results Are InMerge...
What is the most effective way of iterating a std::vector and why?
Are there incongruent pythagorean triangles with the same perimeter and same area?
Resizing object distorts it (Illustrator CC 2018)
Multiply Two Integer Polynomials
slides for 30min~1hr skype tenure track application interview
Why can Shazam fly?
If I score a critical hit on an 18 or higher, what are my chances of getting a critical hit if I roll 3d20?
How to answer pointed "are you quitting" questioning when I don't want them to suspect
Where to refill my bottle in India?
Why isn't the circumferential light around the M87 black hole's event horizon symmetric?
Is there a symbol for a right arrow with a square in the middle?
Is this app Icon Browser Safe/Legit?
Why is the maximum length of OpenWrt’s root password 8 characters?
Right tool to dig six foot holes?
What does ひと匙 mean in this manga and has it been used colloquially?
Are spiders unable to hurt humans, especially very small spiders?
Time travel alters history but people keep saying nothing's changed
How to deal with speedster characters?
Why isn't airport relocation done gradually?
When should I buy a clipper card after flying to OAK?
Did Scotland spend $250,000 for the slogan "Welcome to Scotland"?
Is "plugging out" electronic devices an American expression?
Feature engineering suggestion required
Pokemon Turn Based battle (Python)
Spreadsheet formatting [on hold]
The 2019 Stack Overflow Developer Survey Results Are InMerge fields in a fileHow to paste an HTML table into Libre Office Calc without losing structureMove files/table following selection criteriaReplace values in a tableDelete columns that sum to zeroExtracting quoted and labelled data from a given columnFinding the different possible combinationsMatch File1 with File 2Compare Columns of genes in file and output the gene and number of column it is present in linuxAdding more information to a string
.everyoneloves__top-leaderboard:empty,.everyoneloves__mid-leaderboard:empty,.everyoneloves__bot-mid-leaderboard:empty{ margin-bottom:0;
}
I have gene name in column 1 and respective diseases in column 2 as shown in table 1,Now i want the format to be gene name in column1 and all respective diseases row wise as shown in table 2, Can anyone suggest me solution for reformatting this table
bioinformatics table
New contributor
Yashwanth Kumar is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.
put on hold as off-topic by Ruban Savvy, HBruijn, Stephen Kitt, Rui F Ribeiro, Romeo Ninov 20 hours ago
- This question does not appear to be about Unix or Linux within the scope defined in the help center.
If this question can be reworded to fit the rules in the help center, please edit the question.
add a comment |
I have gene name in column 1 and respective diseases in column 2 as shown in table 1,Now i want the format to be gene name in column1 and all respective diseases row wise as shown in table 2, Can anyone suggest me solution for reformatting this table
bioinformatics table
New contributor
Yashwanth Kumar is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.
put on hold as off-topic by Ruban Savvy, HBruijn, Stephen Kitt, Rui F Ribeiro, Romeo Ninov 20 hours ago
- This question does not appear to be about Unix or Linux within the scope defined in the help center.
If this question can be reworded to fit the rules in the help center, please edit the question.
1
This is not related to Unix & Linux, but with the use of Office suites. Please read unix.stackexchange.com/help/on-topic
– Panki
21 hours ago
4
I'm voting to close this question as off-topic because this is wrt office suite & not Unix and Linux
– Ruban Savvy
21 hours ago
It maybe technically 'off-topic' but the solution is simple and introduces OP to the command line..... isn't that a good thing? We all had to start somewhere.
– bu5hman
20 hours ago
Voting to leave open, since it's about what appears to be LibreOffice on Ubuntu.
– muru
20 hours ago
add a comment |
I have gene name in column 1 and respective diseases in column 2 as shown in table 1,Now i want the format to be gene name in column1 and all respective diseases row wise as shown in table 2, Can anyone suggest me solution for reformatting this table
bioinformatics table
New contributor
Yashwanth Kumar is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.
I have gene name in column 1 and respective diseases in column 2 as shown in table 1,Now i want the format to be gene name in column1 and all respective diseases row wise as shown in table 2, Can anyone suggest me solution for reformatting this table
bioinformatics table
bioinformatics table
New contributor
Yashwanth Kumar is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.
New contributor
Yashwanth Kumar is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.
edited 20 hours ago


roaima
46.1k758124
46.1k758124
New contributor
Yashwanth Kumar is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.
asked 22 hours ago
Yashwanth KumarYashwanth Kumar
1
1
New contributor
Yashwanth Kumar is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.
New contributor
Yashwanth Kumar is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.
Yashwanth Kumar is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.
put on hold as off-topic by Ruban Savvy, HBruijn, Stephen Kitt, Rui F Ribeiro, Romeo Ninov 20 hours ago
- This question does not appear to be about Unix or Linux within the scope defined in the help center.
If this question can be reworded to fit the rules in the help center, please edit the question.
put on hold as off-topic by Ruban Savvy, HBruijn, Stephen Kitt, Rui F Ribeiro, Romeo Ninov 20 hours ago
- This question does not appear to be about Unix or Linux within the scope defined in the help center.
If this question can be reworded to fit the rules in the help center, please edit the question.
1
This is not related to Unix & Linux, but with the use of Office suites. Please read unix.stackexchange.com/help/on-topic
– Panki
21 hours ago
4
I'm voting to close this question as off-topic because this is wrt office suite & not Unix and Linux
– Ruban Savvy
21 hours ago
It maybe technically 'off-topic' but the solution is simple and introduces OP to the command line..... isn't that a good thing? We all had to start somewhere.
– bu5hman
20 hours ago
Voting to leave open, since it's about what appears to be LibreOffice on Ubuntu.
– muru
20 hours ago
add a comment |
1
This is not related to Unix & Linux, but with the use of Office suites. Please read unix.stackexchange.com/help/on-topic
– Panki
21 hours ago
4
I'm voting to close this question as off-topic because this is wrt office suite & not Unix and Linux
– Ruban Savvy
21 hours ago
It maybe technically 'off-topic' but the solution is simple and introduces OP to the command line..... isn't that a good thing? We all had to start somewhere.
– bu5hman
20 hours ago
Voting to leave open, since it's about what appears to be LibreOffice on Ubuntu.
– muru
20 hours ago
1
1
This is not related to Unix & Linux, but with the use of Office suites. Please read unix.stackexchange.com/help/on-topic
– Panki
21 hours ago
This is not related to Unix & Linux, but with the use of Office suites. Please read unix.stackexchange.com/help/on-topic
– Panki
21 hours ago
4
4
I'm voting to close this question as off-topic because this is wrt office suite & not Unix and Linux
– Ruban Savvy
21 hours ago
I'm voting to close this question as off-topic because this is wrt office suite & not Unix and Linux
– Ruban Savvy
21 hours ago
It maybe technically 'off-topic' but the solution is simple and introduces OP to the command line..... isn't that a good thing? We all had to start somewhere.
– bu5hman
20 hours ago
It maybe technically 'off-topic' but the solution is simple and introduces OP to the command line..... isn't that a good thing? We all had to start somewhere.
– bu5hman
20 hours ago
Voting to leave open, since it's about what appears to be LibreOffice on Ubuntu.
– muru
20 hours ago
Voting to leave open, since it's about what appears to be LibreOffice on Ubuntu.
– muru
20 hours ago
add a comment |
1 Answer
1
active
oldest
votes
Save the table in csv format (e.g. myTable.csv), manipulate the columns in awk
or similar
awk -F, '{ print $2","$1"}' myTable.csv > myNewTable.csv
Open the new file (myNewTable.csv).
That transposes the list. It doesn't do what the OP's asking.
– roaima
20 hours ago
add a comment |
1 Answer
1
active
oldest
votes
1 Answer
1
active
oldest
votes
active
oldest
votes
active
oldest
votes
Save the table in csv format (e.g. myTable.csv), manipulate the columns in awk
or similar
awk -F, '{ print $2","$1"}' myTable.csv > myNewTable.csv
Open the new file (myNewTable.csv).
That transposes the list. It doesn't do what the OP's asking.
– roaima
20 hours ago
add a comment |
Save the table in csv format (e.g. myTable.csv), manipulate the columns in awk
or similar
awk -F, '{ print $2","$1"}' myTable.csv > myNewTable.csv
Open the new file (myNewTable.csv).
That transposes the list. It doesn't do what the OP's asking.
– roaima
20 hours ago
add a comment |
Save the table in csv format (e.g. myTable.csv), manipulate the columns in awk
or similar
awk -F, '{ print $2","$1"}' myTable.csv > myNewTable.csv
Open the new file (myNewTable.csv).
Save the table in csv format (e.g. myTable.csv), manipulate the columns in awk
or similar
awk -F, '{ print $2","$1"}' myTable.csv > myNewTable.csv
Open the new file (myNewTable.csv).
answered 20 hours ago


bu5hmanbu5hman
1,356415
1,356415
That transposes the list. It doesn't do what the OP's asking.
– roaima
20 hours ago
add a comment |
That transposes the list. It doesn't do what the OP's asking.
– roaima
20 hours ago
That transposes the list. It doesn't do what the OP's asking.
– roaima
20 hours ago
That transposes the list. It doesn't do what the OP's asking.
– roaima
20 hours ago
add a comment |
1
This is not related to Unix & Linux, but with the use of Office suites. Please read unix.stackexchange.com/help/on-topic
– Panki
21 hours ago
4
I'm voting to close this question as off-topic because this is wrt office suite & not Unix and Linux
– Ruban Savvy
21 hours ago
It maybe technically 'off-topic' but the solution is simple and introduces OP to the command line..... isn't that a good thing? We all had to start somewhere.
– bu5hman
20 hours ago
Voting to leave open, since it's about what appears to be LibreOffice on Ubuntu.
– muru
20 hours ago