Topic starter
As above, is there a simple way of making a list become column headers.
Posted : 13/05/2011 2:07 pm
copy paste special, transpose
Posted : 13/05/2011 2:08 pm
not sure what you want, but if it's data in rows that you want in columns, copy, paste special, check 'transpose'
Posted : 13/05/2011 2:09 pm
bugger! 30 seconds too slow!
Posted : 13/05/2011 2:09 pm
suck my shiney tabulated arse cheesyboy.
Posted : 13/05/2011 2:10 pm
if you want it dynamic then use the TRANSPOSE function (an array function so enter with CTRL + SHIFT + ENTER)
Posted : 13/05/2011 2:15 pm
Topic starter
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?
Posted : 13/05/2011 2:17 pm
Depends on your id data, but s combination of MATCH, ADDRESS, LOOKUP, INDEX etc would do it.
Posted : 13/05/2011 2:27 pm
ctrl-alt-delete
Posted : 13/05/2011 3:04 pm
mrmo - back at proper computer now if you want a hand. you can email it if you like.
Posted : 13/05/2011 4:20 pm
ALT+F4
Posted : 13/05/2011 4:21 pm