Hi,

I have 2 sets of data which is copied directly from our measuring systems for a process we are monitoring. The format and structure of the data in the Link and K-FACTOR Worksheets cannot be modified. There will be more data to be added from other external data all of which will be cross referenced in the Combined worksheet

The COMBINED Worksheet is mine and I am trying to collect the data and format it in a user friendly way for further processing.

I want to list the actual values for each sample(Mostly 16 Samples but i need it automated) under a given lot number which is common to both LINK and K-FACTOR WORKSHEETS. The Link Data is listed horizontally under the Lot number but the K-Factor data is listed vertically under the LOT number - I need to merge them vertically under the COMBINED TAB - I need to make sure that it only pulls in the correct data for the correct LOT number.

All help is appreciated

Attached Files

Link and Lot Data from RE.xlsx (220.8 KB, 13 views)