data assistant

I have quite a few spreadsheets that have on the same lines category data and answers to questions. This doesn't fit well into pivot tables as everything is on one line.

I have seen the notes in this site and the code that would convert my data into a format that could then be easily summarised in a pivot table. I have never had the head space to try and do it.

Is this what data assistant is for??

I don't know what you mean by "Data Assistant"... some product ? can you explain a bit more ?

In this site (mr excel) there is a product for sale called "25 time saving utilities". In it there is a "data asssitant". It is this product I am referring to.

I'm the author of the Data Assistant. The best way to visualize how it works is to picture a report that has as its column titles Jan, Feb, Mar,...Dec. Each row consists of some form of data. One row may be sales units, another sales $. The Data Assistant will create on a new sheet a table that has all the row descriptors in it. Then next to that is a column contianing the month names. And next to that a column containing the values. This resulting table can be used by the pivot table feature of excel.

If you have multiple reports, the converted data for one be placed below the other so the pivot table feature can act on all the data.

Bob Flanagan