"notso" wrote:
Unfortunately, I can't reformat the data.
It comes to me in the form I provided.

But my earlier response assumed the posted source data in Sheet2 "as-is" ?
Only the outputs were in a slightly different "columnar" format.

Anyway, to get it "horizontally" laid out (& with the numeric results
concatenated in a single col C), we could try this extension to the earlier
set-up ...

A new sample is available at:
http://www.savefile.com/files/466960
Multi_criteria_match_n_extract_multi_results_2.xls

In a new Sheet1a,

In A1: =OFFSET(Sheet1!$A$1,COLUMN()-1,ROW()-1)
Copy A1 to B1

In C1:
=SUBSTITUTE(TRIM(D1&" "&E1&" "&F1&" "&G1&" "&H1&" "&I1&" "&J1&" "&K1&"
"&L1&" "&M1)," ",", ")

In D1: =OFFSET(Sheet1!$A$1,COLUMN()-2,ROW()-1)
Copy D1 to M1, ie copy across to the same extent as filled down in Sheet1.
The fill down there was for 10 rows. Then select A1:M1, copy down to M2. Hide
away cols D to M, if desired. The above will return the results in the
required horizontal format within cols A to C.

If you can live with the numeric results not being concatenated in col C,
then it's much easier. Just copy the formula in A1 [ie:
=OFFSET(Sheet1!$A$1,COLUMN()-1,ROW()-1) ] right across as far as required,
then fill down to row2. This will yield the dynamic transpose of what's in
Sheet1's cols A and B, which is a very close 99.9% fit to your original specs
on the results.
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---