Hello, I need a vba code that transforms the columns into rows without transposing the table. Please see attached example. I have a call that can have multiple products detailed to it. Once i separate the text into columns, for each Call ID I have several product columns. What i would like to do is to duplicate the Call ID for each product. Your support is greatly appreciated.
Solved by I. J. in 13 mins