Hi,
Workbook Master has 3 worksheet. Two worksheet as mentioned below and final worksheet need to create from other 2 by transpose and Vlookup.
Worksheet1: ReportConfig
<tbody>
</tbody>
Worksheet2: MeasurementIdentity
<tbody>
</tbody>
Worksheet3: FinalWorksheet ( i want for report config 3,23,27,28,30,31 below parameter)
<tbody>
</tbody>
Workbook Master has 3 worksheet. Two worksheet as mentioned below and final worksheet need to create from other 2 by transpose and Vlookup.
Worksheet1: ReportConfig
Site Id | Report Config | A3offset | Hysteris |
64001_1 | 1 | 2 | 1 |
64001_1 | 3 | 3 | 1 |
64001_1 | 23 | 4 | 1 |
64001_12 | 1 | 8 | 2 |
64001_12 | 3 | 2 | 3 |
64001_12 | 23 | 5 | 6 |
<tbody>
</tbody>
Worksheet2: MeasurementIdentity
Site Id | Report Config | Measurement Identiy | Measurement Object |
64001_1 | 1 | 0 | 1 |
64001_1 | 3 | 3 | 2 |
64001_1 | 23 | 22 | 2 |
64001_12 | 3 | 3 | 1 |
64001_12 | 1 | 0 | 0 |
<tbody>
</tbody>
Worksheet3: FinalWorksheet ( i want for report config 3,23,27,28,30,31 below parameter)
Site Id | Report Config 3 A3offset | Report Config 3 Hysteris | Measurement Identity (Report Config3) | Measurement Object (Report Config3) | ReportConfig23 A3Offset | ReportConfig23 Hystersis | Measurement Identity (Report Config23) | Measurement Object (Report Config23) |
64001_1 | 2 | 1 | 3 | 2 | 4 | 1 | 22 | 2 |
64001_12 | 2 | 3 | 3 | 1 | 5 | 6 |
<tbody>
</tbody>