Do you need this for a few specific fields, known up front, or are you looking for a more generic solution somehow?
If some specific known fields, I guess something along the lines of below should work.
| stats latest(_raw) as F1_raw by index,sourcetype
| append [
| stats latest(_raw) as F2_raw by index,sourcetype
| stats values(F1_raw) as Field_1 values(F2_raw) as Field_2 by index,sourcetype