Hello, I need help moving vertical data from Sheet 1 to horizontal on Sheet 2 thru a macro only, not a formula or copy and paste. Please see below.
SHEET 1
Due to headers on Sheet 1, data list starts at Cell A9 and currently ends at cell A150
<tbody>
</tbody>
SHEET 2 - Job# and Job Name to be listed on cell A1 and A2. Data list to start on cell B1
<tbody>
</tbody>
Thank you.
SHEET 1
Due to headers on Sheet 1, data list starts at Cell A9 and currently ends at cell A150
Job # | Job Name |
1 | A |
2 | B |
3 | C |
4 | D |
5 | E |
<tbody>
</tbody>
SHEET 2 - Job# and Job Name to be listed on cell A1 and A2. Data list to start on cell B1
Job # | 1 | 2 | 3 | 4 | 5 |
Job Name | A | B | C | D | E |
<tbody>
</tbody>
Thank you.