My source data and the format I want to maintain it in is:
1H09 Grp1 item1
1H09 Grp1 item2
1H09 Grp1 item3
1H09 Grp2 item4
1H09 Grp2 item5
2H09 Grp1 item6
2H09 Grp1 item7
2H09 Grp2 item8
2H09 Grp2 item9
2H09 Grp2 item10
The number of Groups and the number of Items is
variable for a given timeframe.
Want to generate a table/report with:
Two column headings of (timeframe) 1H09 and 2H09
Two Row Headings of Grp1 and Grp2
and the list of items in the intersection of the
grid of the headings.
-------------------------1H09-------------------2H09
--------------------------------------------------------------
-------------------------Item1------------------Item6
Grp1------------------Item2------------------Item 7
-------------------------Item3
-------------------------------------------------------------
-------------------------Item4------------------Item8
Grp2------------------Item5------------------Item9
---------------------------------------------------Item10
I thought pivot table would be the solution but Item is a non-numeric
so doesn't work. How can I automate the generation of the
report but maintain it in the source format?
Bookmarks