Here is something so simple that I just discovered tonight while double checking some documentation I wrote recently.
Read more after the jump.
As the original how to article explained, simply highlight the rows you’d like to take out to Excel. Then right click and choose “Copy to clipboard”.
Take it into Excel and paste.
The question I had was “What is the difference between ‘Copy to Clipboard’ and ‘Copy Value to Clipboard’?” I had tried it a few times from Panorama and Prospector and I couldn’t seem to get anything to happen.
Well, if you choose “Copy Value to Clipboard” it only takes the data from the column you are hovering over when you right click.
Like I said, simple. But somehow it had eluded me until just now, so I figured there were other folks out there who might be in the same boat.