I'm trying to get a list of every orrurance when comparing a Column value (A,
B, C) to a Row Heading (2006, 2007, 2008)

Col A
Row 1 (Col B-D) 2006 2007 2008
A
B
C

On a separate Work sheet I'd like to get 2 columns - all possible occurances

A 2006
A 2007
A 2008
B 2006
B 2007
B 2008
C 2006
C 2007
C 2008

I can do this in Access by just pulling 2 tables of data (A,B,C) and (2006,
2007, 2008) into a query and just not linking the tables. Don;t know how to
do this in ExceL

Assume the scenario you posted is in Sheet1
In Sheet2,
In A2: =OFFSET(Sheet1!$A$2,INT((ROWS($1:1)-1)/3),)
In B2: =INDEX(Sheet1!$B$1:$D$1,MOD(ROWS($1:1)-1,3)+1)
Copy A2:B2 down as far as required
--
Max
Singapore
http://savefile.com/projects/236895
Downloads:22,500 Files:370 Subscribers:66
xdemechanik
---
"rrcd124" wrote:
I'm trying to get a list of every occurance when comparing a Column value (A,
B, C) to a Row Heading (2006, 2007, 2008)

Col A
Row 1 (Col B-D) 2006 2007 2008
A
B
C

On a separate Work sheet I'd like to get 2 columns - all possible occurances

A 2006
A 2007
A 2008
B 2006
B 2007
B 2008
C 2006
C 2007
C 2008

I can do this in Access by just pulling 2 tables of data (A,B,C) and (2006,
2007, 2008) into a query and just not linking the tables. Don;t know how to
do this in ExceL

Excel 2007
Without formulas or code.
http://www.mediafire.com/file/mmymimmz2m2/02_02_09.xlsx