O'Reilly Answers is a community site for sharing knowledge, asking questions, and providing answers that brings together our customers, authors, editors, conference speakers, and Foo (Friends of O'Reilly). More »
I often encounter the term "pivot table," yet until recently I had only a vague notion as to what a pivot table is and what it does. Matthew MacDonald, author of "Excel 2010: The Missing Manual," got ...
Answered by Matthew MacDonald : Sep 08 2010 04:31 PM
Hi,
We may need a few more details. I'm assuming you're working through the steps on page 167. I just tried them again (using the downloadable sample file), and verified that it works. Howeve... full answer >
If you have a table that maintains current values of items that you
track (such as auctions being bid on), but you’d also like to maintain
a journal (or history) of changes to...
If you need into create a table that has exactly the same structure
as an existing table, use CREATE TABLE ... LIKE to clone the
table structure. If it’s also necessary to copy s...