VBA Code: How to Transpose Column B Values based on Column A Values?

ridwan102

New Member
Joined
Dec 5, 2017
Messages
1
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_3Point_4Point_5
No DataNo DataNo DataNo DataNo 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>
 

Some videos you may like

Excel Facts

Get help while writing formula
Click the italics "fx" icon to the left of the formula bar to open the Functions Arguments dialog. Help is displayed for each argument.

Watch MrExcel Video

Forum statistics

Threads
1,122,556
Messages
5,596,820
Members
414,104
Latest member
imamalidadashzada

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top