Array formula required to get the Employee details

Hi Everybody,

In attached file i have two sheets named 'Raw' and 'output'. I wanted to extract the employee performance details from Raw sheet into the output sheet. The user only needs to put or select the Employee ID. i am holding nearly 2000 records in my raw sheet but i have not attached all the data. I need a array formula or other formula to extract the details. The extracted data should be adjusted column(append or Blank) based on the number of records retrieve. Please help me to solve these issue. Thanks in advance.