Formula/ method to sort data in Excel

[MLCR]

Hi,

We manage admissions data back-end. Our applicants go through interviews with 2 interviewers and this data sample is automatically populated using MS forms and Power Automate.

However, this is what we need for the compilation of data in our mastersheet.

For every 2nd interviewer, we need the columns of interviewer 2's name, EQ, IQ, AQ score and comments to be beside interviewer 1's data. We are trying to avoid having to copy and paste because we have hundreds of applicants.

Any formulas/ other methods are welcomed.

 

[JB2020]

Hi

I'm not sure how you determine which is the second interview (or whether that matters?). However, it sounds like this is probably a job for Power Query.
I would add a column labelling the interview number (1 or 2), then load the table to power query and Filter out all the 2's. Then do the same again and filter all the 1's. You could then do a merge query based on the application number to join the 2 tables together.