G
Guest
Hi,
I have a worksheet (lets call it W1) which is nearly full with data. I wish
to put this data into a second worksheet (W2) but with all the data
transposed. Here's the tricky bit. I want the data in W2 to update if I alter
anything in W1. Is it possible to transpose all of the data at once.....or do
I have to do row by row?
Thanks in advance.
I have a worksheet (lets call it W1) which is nearly full with data. I wish
to put this data into a second worksheet (W2) but with all the data
transposed. Here's the tricky bit. I want the data in W2 to update if I alter
anything in W1. Is it possible to transpose all of the data at once.....or do
I have to do row by row?
Thanks in advance.