Apologies, ignore the second image. Ideally, I would like to transpose the values to a new worksheet in the same workbook. Thanks in advance!