Transfer dynamic many-column labeled data from MySQL to Excel-like layout - MySQL Pivot Table

Excel is a de facto tool for day-to-day matters inside the lab (unfortunately). Say you are collecting information from several sources (or better you have automated that process into a multithreaded crawler) and curating them into one beautiful excel sheet. One problem that may occur quite early is that you end up with a huge excel sheet, and as result your biologist will start going insane or ask you to link an item to something in the database. Hence, the next logical step is to transfer your information into a relational database.

An example of data source: http://www.ncbi.nlm.nih.gov/gene/2218,

enter image description here

"Official Symbol", "Locus tag" being the labels. Continue reading Transfer dynamic many-column labeled data from MySQL to Excel-like layout - MySQL Pivot Table