| Looking for help on a code that will automatically detect Column A is a "Point_#" and then transpose value in Column B in row above "Point_#" row. Please let me know if anyone can help or if I need to clarify. Columns: Key Name:Suffix Trend Definitions Used | |
| Point_1: | pa01AF |
| Point_2: | pa01DE |
| Point_3: | pa01DM |
| Point_4: | pa01DO |
| Point_5: | pa01DR |
| Point_6: | pa01FR |
| Point_7: | pa01FS |
| Point_8: | pa01MD |
| Point_9: | pa01MO |
| Point_10: | pa01PD |
| Time Interval: | 15 Minutes |
| Date Range: | 5/23/2017 00:00:00 - 6/6/2017 23:59:59 |
<colgroup><col style="mso-width-source:userset;mso-width-alt:6765;width:139pt" width="185"> <col style="mso-width-source:userset;mso-width-alt:8960;width:184pt" width="245"> </colgroup><tbody>
</tbody>
Rows:
| Point_1 | Point_2 | Point_3 | Point_4 | Point_5 |
| No Data | No Data | No Data | No Data | No Data |
<colgroup><col style="width:48pt" width="64"> <col style="mso-width-source:userset;mso-width-alt:5705;width:117pt" width="156"> <col style="mso-width-source:userset;mso-width-alt:6948;width:143pt" width="190"> <col style="mso-width-source:userset;mso-width-alt:4864;width:100pt" width="133"> <col style="mso-width-source:userset;mso-width-alt:5741;width:118pt" width="157"> </colgroup><tbody>
</tbody>
