Sorting Data

[johndoh453]

I have a set of data that I would like to sort in sheet 1 and be placed into sheet 2. Each "sample" has three different conditions: a Test (TST), a Control (CTL), and a Reference (REF). I would like to create two tables in sheet 2, one for test and one for control.

Column A is the location of the sample. There are three rows for each location, one for test, control, and reference.

Column B is the Sample identification. However, the real ID is in column K. I drop off the last four digits each time.

Column G contains the data that I am looking for in this test.

I would like to have a macro that would pull together all the samples, list their location, and list the value in either table 1 or 2, depending on if its test or control. Table 1 would be the test values and Table 2 would be the control values.

I've attached the spreadsheet with some numbers I've put together and on sheet 2 where the tables would be created, I've manually typed in what I am looking to have a macro do.

Thank you.