How to transform raw data into a table using index match in less than 2 minutes!
For scientists, one of the most common things that needs to be done is to organize raw data into tables. Raw data from instrument software are huge and extracting the necessary information can be time consuming. Dealing with large amounts of data can take away time from planning experiments or doing research. So how can you transform your raw data into organized tables in a few minutes? Index Match!
In this example, we want to report the % of label claim of the compound and its impurities and retrieve the values from the raw data. Watch the video to learn how to do this in less than 2 minutes!
If you like this video, please subscribe to our channel for more content about excel for scientists!