select multiple values in same row only display true values

[Guest]

I have a large Excel spreadsheet imported to access and would like to get
data from multiple rows but only show the colunm heading where the value that
meets the criteria appear in the queary or report

 

[John Vinson]

I have a large Excel spreadsheet imported to access and would like to get
data from multiple rows but only show the colunm heading where the value that
meets the criteria appear in the queary or report

So if you have 1000 rows, all with different contents, you want each
row to have different headers?

Access simply doesn't work that way. I would strongly suggest
normalizing your data; rather than a different FIELD for each value,
use a different RECORD. It sounds like you have a classic many to many
relationship between whatever is in the rows of your spreadsheet and
the values in the column headers. A two-field table with the row
identifier and the column heading as field values will let you
represent this information in a normalized table structure.

John W. Vinson[MVP]