I have been using STL containers to store structures of data but I would like
to know if there is an easier solution such as a dynamically sized container
that stores data in a spreadsheet like fashion.

For example, I would like to store rows of columns of different data types.

Here is a sample of data I would like to store, also, I would like fast random
access to the elements to read and modify existing data:

Name, Age, HomeOwner
John 42 true
Mark 24 false
Mary 29 true

If anyone can suggest such a container please let me know.

boost::tuple (now tr1::tuple) will do:

Something like:
boost::tuple<std::string, int, std::string>