Returning listed values from a table

[Charmwah]

Hi all

I have a populated data base where each row represents a customer, and each column represents a product. Some columns are subdivided where a product has variants. All I want to do is create a simple worksheet where a product can be selected from a drop down list, and then all the customers that currently order it are listed. The database looks basically like below, albeit on a larger scale:

[TABLE="width: 221"]
<colgroup><col><col><col><col></colgroup><tbody>[TR]
[TD][/TD]
[TD][/TD]
[TD="colspan: 2"]Product A[/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD]Product A1[/TD]
[TD]Product A2[/TD]
[/TR]
[TR]
[TD="colspan: 2"]Customer A[/TD]
[TD]X[/TD]
[TD][/TD]
[/TR]
[TR]
[TD="colspan: 2"]Customer B[/TD]
[TD][/TD]
[TD]X[/TD]
[/TR]
[TR]
[TD="colspan: 2"]Customer C[/TD]
[TD]X[/TD]
[TD]X[/TD]
[/TR]
</tbody>[/TABLE]

The issue i'm having is in finding a formula that can a) return the list of customers showing each value in its own cell and the next value in the cell below, and b) without any showing anyblank cells.

Can anybody suggest a way to do this without the use of VBA?

Thanks in advance!!!

 

[jarjarbingie]

Hi all

I have a populated data base where each row represents a customer, and each column represents a product. Some columns are subdivided where a product has variants. All I want to do is create a simple worksheet where a product can be selected from a drop down list, and then all the customers that currently order it are listed. The database looks basically like below, albeit on a larger scale:

[TABLE="width: 221"]
<tbody>[TR]
[TD][/TD]
[TD][/TD]
[TD="colspan: 2"]Product A[/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD]Product A1[/TD]
[TD]Product A2[/TD]
[/TR]
[TR]
[TD="colspan: 2"]Customer A[/TD]
[TD]X[/TD]
[TD][/TD]
[/TR]
[TR]
[TD="colspan: 2"]Customer B[/TD]
[TD][/TD]
[TD]X[/TD]
[/TR]
[TR]
[TD="colspan: 2"]Customer C[/TD]
[TD]X[/TD]
[TD]X[/TD]
[/TR]
</tbody>[/TABLE]

The issue i'm having is in finding a formula that can a) return the list of customers showing each value in its own cell and the next value in the cell below, and b) without any showing anyblank cells.

Can anybody suggest a way to do this without the use of VBA?

Thanks in advance!!!

I think it will be much easier if you can share the file..

 

[Charmwah]

I think it will be much easier if you can share the file..

Hi JarJar

Thanks for your response. I'm afraid i'm unable to share the file due to the nature of its content. I could perhaps produce a replica with none of the private information within?

Thanks

Dave

 

[jarjarbingie]

hi jarjar

thanks for your response. I'm afraid i'm unable to share the file due to the nature of its content. I could perhaps produce a replica with none of the private information within?

Thanks

dave

ygpm