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
writing variables above the numbers in tikz picture
What is this business jet?
If I score a critical hit on an 18 or higher, what are my chances of getting a critical hit if I roll 3d20?
Geography at the pixel level
Deal with toxic manager when you can't quit
Does adding complexity mean a more secure cipher?
Can we generate random numbers using irrational numbers like π and e?
Time travel alters history but people keep saying nothing's changed
How to translate "being like"?
A female thief is not sold to make restitution -- so what happens instead?
Why “相同意思的词” is called “同义词” instead of "同意词"？
I am an eight letter word. What am I?
What to do when moving next to a bird sanctuary with a loosely-domesticated cat?
Can you cast a spell on someone in the Ethereal Plane, if you are on the Material Plane and have the True Seeing spell active?
Cooking pasta in a water boiler
"as much details as you can remember"
Why was M87 targeted for the Event Horizon Telescope instead of Sagittarius A*?
Why not take a picture of a closer black hole?
What does Linus Torvalds mean when he says that Git "never ever" tracks a file?
What could be the right powersource for 15 seconds lifespan disposable giant chainsaw?
Dropping list elements from nested list after evaluation
Is it safe to harvest rainwater that fell on solar panels?
How do PCB vias affect signal quality?
Is bread bad for ducks?
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
edited yesterday
roaima
46.1k758124
asked yesterday
Yashwanth KumarYashwanth Kumar
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.
put on hold as off-topic by Ruban Savvy, HBruijn, Stephen Kitt, Rui F Ribeiro, Romeo Ninov yesterday
- This question does not appear to be about Unix or Linux within the scope defined in the help center.
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
edited yesterday
roaima
46.1k758124
asked yesterday
Yashwanth KumarYashwanth Kumar
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.
put on hold as off-topic by Ruban Savvy, HBruijn, Stephen Kitt, Rui F Ribeiro, Romeo Ninov yesterday
- This question does not appear to be about Unix or Linux within the scope defined in the help center.
1
This is not related to Unix & Linux, but with the use of Office suites. Please read unix.stackexchange.com/help/on-topic
– Panki
yesterday
4
I'm voting to close this question as off-topic because this is wrt office suite & not Unix and Linux
– Ruban Savvy
yesterday
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
yesterday
Voting to leave open, since it's about what appears to be LibreOffice on Ubuntu.
– muru
yesterday
It’s about LibreOffice, yes, but there’s nothing specific to Unix/Linux here. I don’t know whether there’s a better SE for this though...
– Stephen Kitt
19 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
edited yesterday
roaima
46.1k758124
asked yesterday
Yashwanth KumarYashwanth Kumar
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.
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
edited yesterday
roaima
46.1k758124
asked yesterday
Yashwanth KumarYashwanth Kumar
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.
edited yesterday
roaima
46.1k758124
asked yesterday
Yashwanth KumarYashwanth Kumar
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.
edited yesterday
roaima
46.1k758124
edited yesterday
roaima
46.1k758124
edited yesterday
roaima
46.1k758124
46.1k758124
asked yesterday
Yashwanth KumarYashwanth Kumar
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.
asked yesterday
Yashwanth KumarYashwanth Kumar
1
asked yesterday
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 yesterday
- This question does not appear to be about Unix or Linux within the scope defined in the help center.
put on hold as off-topic by Ruban Savvy, HBruijn, Stephen Kitt, Rui F Ribeiro, Romeo Ninov yesterday
- This question does not appear to be about Unix or Linux within the scope defined in the help center.
1
This is not related to Unix & Linux, but with the use of Office suites. Please read unix.stackexchange.com/help/on-topic
– Panki
yesterday
4
I'm voting to close this question as off-topic because this is wrt office suite & not Unix and Linux
– Ruban Savvy
yesterday
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
yesterday
Voting to leave open, since it's about what appears to be LibreOffice on Ubuntu.
– muru
yesterday
It’s about LibreOffice, yes, but there’s nothing specific to Unix/Linux here. I don’t know whether there’s a better SE for this though...
– Stephen Kitt
19 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
yesterday
4
I'm voting to close this question as off-topic because this is wrt office suite & not Unix and Linux
– Ruban Savvy
yesterday
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
yesterday
Voting to leave open, since it's about what appears to be LibreOffice on Ubuntu.
– muru
yesterday
It’s about LibreOffice, yes, but there’s nothing specific to Unix/Linux here. I don’t know whether there’s a better SE for this though...
– Stephen Kitt
19 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
yesterday
This is not related to Unix & Linux, but with the use of Office suites. Please read unix.stackexchange.com/help/on-topic
– Panki
yesterday
4
4
I'm voting to close this question as off-topic because this is wrt office suite & not Unix and Linux
– Ruban Savvy
yesterday
I'm voting to close this question as off-topic because this is wrt office suite & not Unix and Linux
– Ruban Savvy
yesterday
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
yesterday
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
yesterday
Voting to leave open, since it's about what appears to be LibreOffice on Ubuntu.
– muru
yesterday
Voting to leave open, since it's about what appears to be LibreOffice on Ubuntu.
– muru
yesterday
It’s about LibreOffice, yes, but there’s nothing specific to Unix/Linux here. I don’t know whether there’s a better SE for this though...
– Stephen Kitt
19 hours ago
It’s about LibreOffice, yes, but there’s nothing specific to Unix/Linux here. I don’t know whether there’s a better SE for this though...
– Stephen Kitt
19 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).
answered yesterday
bu5hmanbu5hman
1,356415
That transposes the list. It doesn't do what the OP's asking.
– roaima
yesterday
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).
answered yesterday
bu5hmanbu5hman
1,356415
That transposes the list. It doesn't do what the OP's asking.
– roaima
yesterday
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).
answered yesterday
bu5hmanbu5hman
1,356415
That transposes the list. It doesn't do what the OP's asking.
– roaima
yesterday
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).
answered yesterday
bu5hmanbu5hman
1,356415
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 yesterday
bu5hmanbu5hman
1,356415
answered yesterday
bu5hmanbu5hman
1,356415
answered yesterday
bu5hmanbu5hman
1,356415
answered yesterday
bu5hmanbu5hman
1,356415
1,356415
That transposes the list. It doesn't do what the OP's asking.
– roaima
yesterday
add a comment |
That transposes the list. It doesn't do what the OP's asking.
– roaima
yesterday
That transposes the list. It doesn't do what the OP's asking.
– roaima
yesterday
That transposes the list. It doesn't do what the OP's asking.
– roaima
yesterday
add a comment |
-bioinformatics, table
1
This is not related to Unix & Linux, but with the use of Office suites. Please read unix.stackexchange.com/help/on-topic
– Panki
yesterday
4
I'm voting to close this question as off-topic because this is wrt office suite & not Unix and Linux
– Ruban Savvy
yesterday
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
yesterday
Voting to leave open, since it's about what appears to be LibreOffice on Ubuntu.
– muru
yesterday
It’s about LibreOffice, yes, but there’s nothing specific to Unix/Linux here. I don’t know whether there’s a better SE for this though...
– Stephen Kitt
19 hours ago