i have a database table i wish to concatenate into one column, then i would
like to reference that inforation -column,row and ref individual bits of
information inside of the concatenated data for formaula. is this possible?

ex.. a1:p25 is varied data types - some dates some alphanumeric.
would like to ref for conditional statements.

reason for concatenation is to ref archive data within same worksheet.