Subscribe now and choose from over 30 free gifts worth up to £49 - Plus get £25 to spend in our shop
As above, is there a simple way of making a list become column headers.
copy paste special, transpose
not sure what you want, but if it's data in rows that you want in columns, copy, paste special, check 'transpose'
bugger! 30 seconds too slow!
suck my shiney tabulated arse cheesyboy.
if you want it dynamic then use the TRANSPOSE function (an array function so enter with CTRL + SHIFT + ENTER)
Step one done, thanks. Step two, I have a third column, think x,y grid with a value to plot on z acids. How do I get that value to the right place in the table?
Depends on your id data, but s combination of MATCH, ADDRESS, LOOKUP, INDEX etc would do it.
ctrl-alt-delete
mrmo - back at proper computer now if you want a hand. you can email it if you like.
ALT+F4