<div>
Your example is not alligned so its hard to determine what it is supposed to show. &nbsp;Please tell us in words what you want to do.<br />
<br />
The first input is not normalized so starting from that point, you can't even use a crosstab without creating a union query to normalize the data.<br />
<br />
It looks like you are trying to show which Roles are used together but to what end?
</div>


<div>
So If you read &nbsp;Role 1 in the list you can see Role3 also does the same as Role 1<br />
If you read Row 2 , it only does the role and no other role does what it does .
</div>


<div>
???<br />
I am with Pat, ...please post the actual input table (or spreadsheet)<br />
Then post a spreadsheet of the &quot;exact&quot; output you need.<br />
<br />
JeffCoachman
</div>


pisct.png

yasanthax

<div>
<div class="content wysiwyg-content">
Hi <br />
<br />
I am looking for a solution &nbsp;to look at relationships between matching columns on a records set (see below). &nbsp;This &nbsp;maybe a data manipulation question but I do think I have used an Access cross tab similarly in the past. &nbsp;Can this be done through a Access cross tab and if so how? <br />
<br />
<br />
Example:<br />
Data input &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;<br />
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;Role 1 &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;Role 2 &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;Role 3<br />
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;Process 1 &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;x &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;x<br />
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;Process 2 &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;x &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;<br />
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;<br />
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;<br />
Desired output &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;Role 1 &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;Role 2 &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;Role 3<br />
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;Role 1 &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;x &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;x<br />
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;Role 2 &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;x &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;<br />
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;Role 3 &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;x &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;x
</div>
</div>


Hi 

I am looking for a solution  to look at relationships between matching columns on a records set (see below).  This  maybe a data manipulation question but I do think I have used an Access cross tab similarly in the past.  Can this be done through a Access cross tab and if so how? 


Example:
Data input				
		Role 1	Role 2	Role 3
	Process 1	x		x
	Process 2		x	
				
				
Desired output		Role 1	Role 2	Role 3
	Role 1	x		x
	Role 2		x	
	Role 3	x		x

Access cross tab query used for column relationships

Microsoft Access is a rapid application development (RAD) relational database tool. Access can be used for both desktop and web-based applications, and uses VBA (Visual Basic for Applications) as its coding language.