I’m trying to transpose multiple columns each starting at row 2, all on separate sheets, to a horizontal array on one sheet. Is there a simple way to do this?
I’ve tried pivot, but I don’t know how to get it to work.
I’m trying to transpose multiple columns each starting at row 2, all on separate sheets, to a horizontal array on one sheet. Is there a simple way to do this?
I’ve tried pivot, but I don’t know how to get it to work.