I am trying to do the following using a macro or formula:
from this -
Column A Column B
Row 1 Favorite Color Red
Row 2 Favorite Color Blue
Row 3 Favorite Color Green
to this -
Row 1 Favorite Color
Row 2 Red
Row 3 Favorite Color
Row 4 Blue
Row 5 Favorite Color
Row 6 Green
Solved by M. D. in 24 mins