I have lots of data in various tables across various sheets and what I need is to transpose that data without the formulas behind them to new tables. How can I do this without having to put a cell reference formula into each cell of the new table?
I just need the numbers produced and they have to be final I can't have them updating automatically. I don't want to have to do this by hand, for obvious reasons, so any help would be much appreciated.
Thanks in advance.
I just need the numbers produced and they have to be final I can't have them updating automatically. I don't want to have to do this by hand, for obvious reasons, so any help would be much appreciated.
Thanks in advance.