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;








0















2 formats



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










share|improve this question









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.
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
    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

















0















2 formats



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










share|improve this question









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.
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
    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













0












0








0


1






2 formats



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










share|improve this question









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.












2 formats



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






share|improve this question









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.











share|improve this question









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.









share|improve this question




share|improve this question








edited yesterday









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 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.
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 yesterday



  • 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
    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





    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










1 Answer
1






active

oldest

votes


















-1














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).






share|improve this answer























  • That transposes the list. It doesn't do what the OP's asking.

    – roaima
    yesterday

















1 Answer
1






active

oldest

votes








1 Answer
1






active

oldest

votes









active

oldest

votes






active

oldest

votes









-1














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).






share|improve this answer























  • That transposes the list. It doesn't do what the OP's asking.

    – roaima
    yesterday















-1














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).






share|improve this answer























  • That transposes the list. It doesn't do what the OP's asking.

    – roaima
    yesterday













-1












-1








-1







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).






share|improve this answer













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).







share|improve this answer












share|improve this answer



share|improve this answer










answered yesterday









bu5hmanbu5hman

1,356415




1,356415












  • 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





That transposes the list. It doesn't do what the OP's asking.

– roaima
yesterday



-bioinformatics, table

Popular posts from this blog

Word for a person who has no opinion about whether god existsWord for having a definite opinion while simultaneously withholding judgment?What's the opposite of “newcomer? Is ”veteran" OK?What do you call an “atheist” who might believe in an afterlife?What's a word for someone who wants to voice opinions but not have them challenged?Word for someone who dismisses contrary opinions as irrational?Somone who thinks they are overly special/out of the ordinaryIs there a word, phrase or idiom for “a person who is incapable of thinking about the future”?The belief that a god is human-likeA word for a non-famous person/thing you have heard a lot aboutAdjective for a person who enjoys taking care of their appearance

2017 IndyCar Series Contents Series news Teams and drivers Schedule Season summary Footnotes References External links Navigation menu"INDYCAR: Initial 2018 bodywork concepts unveiled"the original"IndyCar confirms switch to Performance Friction brakes in 2017""AJ Foyt Racing will switch to Chevy"the original"Carlos Munoz, Conor Daly will drive for AJ Foyt Racing""Zach Veach's Indy 500 Debut Confirmed with Foyt""No mass exodus from Honda after Ganassi switch""Ex-F1 driver Sato joins Andretti Autosport for 2017 IndyCar season""IndyCar's Ryan Hunter-Reay, sponsor DHL paired through 2020""hhgregg and Andretti Autosport announce partnership for key races in 2016""INDYCAR: Rossi re-signs with Andretti"the original"McLaren Formula 1 - Fernando Alonso to race at Indy 500 with McLaren, Honda and Andretti Autosport""Shank will finally take part in Indy 500 with Harvey, Andretti | MotorSportsTalk""Andretti adds Jack Harvey to Indy 500 field""Ganassi switches to Honda power for 2017""INDYCAR: Chilton returns to Ganassi"the original"IndyCar silly season: Who's going where in 2017?""INDYCAR: Kanaan, NTT Data return to Ganassi"the original"Kimball to remain at Ganassi for 2017""Coyne confirms Bourdais for 2017 IndyCar season""Davison to sub for Bourdais in Indy 500"the original"Gutierrez confirmed for Detroit IndyCar debut""Gutierrez returns with Coyne for rest of 2017 season""Vautier to drive for Coyne at Texas"the original"INDYCAR: Coyne confirms Jones for 2017"the original"Pippa Mann returns to Coyne for Indy 500""Karam, Dreyer & Reinbold teaming up again for Indianapolis 500""Pigot to return to Ed Carpenter Racing""Hildebrand confirmed as full-time Ed Carpenter driver""Veach to replace injured Hildebrand at Barber"the originalNew Team Harding Racing Enters Chaves for 101st Indianapolis 500"Juncos Racing Announces Entry in 101st Running of the Indianapolis 500 :: Juncos Racing""Juncos confirms Pigot for Indy 500""Saavedra confirmed in Juncos' second 500 entry"the original"Lazier confirms Indy 500 run after son's USF2000 debut"the original"Claman DeMelo to race for RLLR at Sonoma"the original"Rahal signs Servia and ace engineer for 2017""IndyCar: Aleshin returns with Schmidt"the original"Aleshin replaced by Saavedra for Toronto""Jack Harvey will pilot SPM No. 7 car at Watkins Glen, Sonoma""Jay Howard confirmed in Tony Stewart's supported SPM Indy entry""INDYCAR: Newgarden to wave the flag at Penske"the original"Pagenaud opts for No. 1 in 2017"the original"Penske confirms Newgarden for 2017""Montoya to stay with Team Penske in 2017""Target leaving IndyCar after 27 seasons with Chip Ganassi""Cavin: IndyCar could see complete driver/team shakeup in 2017""End of the road for KV Racing?""KV Racing confirms closure, equipment sold to Juncos""Juncos confirms IndyCar Series entry"the original"Juncos readies IndyCar program, aims for '17 500"the original"Harding Racing to add Texas, Pocono to schedule"the original"Sato signs with Andretti Autosport for 2017""INDYCAR: Aleshin in Doubt at SPM"the original"Long Beach notebook: JR Hildebrand breaks hand""Hildebrand cleared to return at Phoenix"the original"Bourdais to undergo surgery on multiple fractures""Aleshin loses Schmidt Peterson IndyCar ride""Saavedra in at SPM for Pocono, Gateway"the original"Bourdais to make return at Gateway"the original"The IndyCar Grand Prix no longer is sponsored by Angie's List""2017 IndyCar Series rulebook""2017 Verizon IndyCar Series Official Rulebook"Official websiteeeeee

What was this official D&D 3.5e Lovecraft-flavored rulebook?What was this set of RPG tools called?As a first-time DM should I let my players play complex character classes and roles?Nymph's Kiss and the RelationshipWhat was the name of this Cleric Prestige Class that shapes metal with its bare hands?Are the 3.5e Dragonlance books third party or official works?What's up with the domain Vile Darkness?What was this 80s book about RPGs?What was the name of this Werewolf band?What book had Rituals to “upgrade” animal companions to keep them viable at higher levels?What was this RPG that had rules for player-owned businesses?