Hey Folks,
I'm hoping for some advise on how to take the value in 1 cell of 1 row and convert it to a different sheet over 4 rows adding some constant text before and after the cell value.
For every row in Sheet1, column H (only if it contains data) I need to use the cell value and add a...