The result in trying to achieve is to have a formula,
On sheet1 in cell A1 return the value on sheet2 A1 and
on sheet1 in cell B1 return the value on sheet2 A2 and
on sheet1 in cell C1 return the value on sheet2 A3 and so on.
By putting a formula in A1 on sheet1 and coping the cells out to the right.
I have tried the offset and the transpose formulas, and different combinations there of, but I cannot get it to work correctly.
I feel I'm on the right track, can anybody guide me to a solution?
Bookmarks