Lookup function to pull data across multiple columns

[templeowls]

I'll try to explain this as best as possible. So I have eight columns in my table that are mutually exclusive events. So entry 2 will only have data in one of the columns, same with row 3 and so on. Is there a way add a column in my table at the very end that pulls the data from whichever column its in and displays it? I feel like it easy to do but I'm just having a brain fart. I have roughly 1200 rows so I'd like to not have to manually type in each row's description. Plus this would allow me to run queries and reports much easier.

[ranman256]

This sounds like the table is designed wrong. You should be adding records, not columns.
can you show example?

[Gicu]

Agree with Ranman on the design issue.

To do what you want you need a query where you add a calculated field that concatenates your eight fields:
Summary:[Field1] & [Field2] & [Field3].........& [Field8]

Cheers,
Vlad