Creating COLUMNS from DATA in Excel 2007

[cubmar]

Hi

I have a worksheet in Excel 2007, which has the following sample data:

Please Login or Register  to view this content.

What I want to achieve is the following:

Please Login or Register  to view this content.

Which uses the data itself to create column headings and then gets the count of each.

Is this possible?

Thanks in advance...

[Max, Singapore]

Here's a 2 stepper to achieve it ...
1st step: Use OFFSET to transform all of the source data (within a rectangular area) into a single long col
Assume the source data as you posted is in Sheet1, where the col labels NoName - Name6 is in B1:H1 (ie 7 cols), with data below
In another sheet,
Put a label into A1, eg: xxx
Put this in A2: =OFFSET(Sheet1!$B$2,INT((ROWS($1:1)-1)/7),MOD(ROWS($1:1)-1,7))
Copy A2 down as far as required to exhaust the source into a single long col
Modify the 7 to suit the actual number of cols of source data that you have

2nd Step: Create a pivot on col A, drag n drop xxx into Col Labels** and Values (as Count), and voila, the desired results should surface
**or into Row Labels (this would be my pref, to have things vertical)
-------------------------
Success? Celebrate it, hit the little star at the bottom left of my response