Excel 2007

In Sheet1 I have data (records) beginning at row 2 thru whatever (say row
318). The number of records can vary. Each record is from column a thru y. I
would like to match column i to either LSTE, LSHG, or Tlibor. When there is a
match take data in column b and k and transpose it to Sheet2 beginning at
cell a1. Column b is text and k is a date. I suppose there could be 318
results but more likely 20 to 30. First match would be data from b in a1,
data from k in a2. Second match would be data from b in b1, data fromk in b2,
etc.

After writing this maybe it would be better to sort on the three items for
column i and copy past (transposing). I just do not know how to do it.

Thank you for looking at my question.