Huseyin ABANOZ

  1.     Introduction Select   count (*),  category ,  subcategory  from   table   where  somecontions = true   group   by  category ,  subcategory Suppose you extracted data from database which contains data according to a category and a shared subcategory. You need to display this data with an excel chart. Unfortunately it is not easy to build a chart using structure of data. It is required to reorganize this data to easily build a chart out of this data. 2.     Problem Definition Category is hour. Sub-category is status. This table contains hourly status values of some variable. To use this data in excel to create a chart, data needs to be re-organized. New table should have a matrix like layout. Row of the matrix should contain category values while Column of the matrix needs to contain sub-category values. Resulted table should look like picture below. 3-...