I was just thinking about data mining relationships between atoms and chemical compounds, and about putting it all into a nice, neat RDBMS for that, when it occurred to me that I’m really not an expert in the field, and designing the database would require more knowledge than I have. However, in a process of… Continue reading RDBMS Table Design in Excel?
Tag: Excel
Copying Collapsed Rows/Columns in Excel Excludes Hidden Data
Excel doesn’t copy collapsed columns or rows, which can be excruciatingly painful to figure out. When copying Excel data into a text editor (or other program), if you have a collapsed row or column, the data will not paste properly. So, imagine you have 51 rows of data. That’s what Excel tells you anyways like… Continue reading Copying Collapsed Rows/Columns in Excel Excludes Hidden Data