Grouping and copying data into other columns

[esuriency]

Hello! I'm not sure how to describe this well, but essential I have rows that contain IP Address and Computer information for a session. The IP Address and Computer info is currently in the same column, but different rows (with same Session).

Sample Excel file here. I'm provided with columns A-K, but need to fill out M-P. M-P would be copied down for all the rows until the Session changes.

Would a vlookup (or something) work for this, or would I need to make a macro?

 

[jarjarbingie]

Hello! I'm not sure how to describe this well, but essential I have rows that contain IP Address and Computer information for a session. The IP Address and Computer info is currently in the same column, but different rows (with same Session).

Sample Excel file here. I'm provided with columns A-K, but need to fill out M-P. M-P would be copied down for all the rows until the Session changes.

Would a vlookup (or something) work for this, or would I need to make a macro?

M2=INDEX($I$2:$I$7,MATCH($C2&"SOURCE",$C$2:$C$7&$A$2:$A$7,0)) press CTRL+SHIFT+ENTER
N2=INDEX($I$2:$I$7,MATCH($C2&"SOURCE_CLIENT",$C$2:$C$7&$A$2:$A$7,0)) press CTRL+SHIFT+ENTER
O2=INDEX($J$2:$J$7,MATCH($C2&"SOURCE_CLIENT",$C$2:$C$7&$A$2:$A$7,0)) press CTRL+SHIFT+ENTER
P2=INDEX($K$2:$K$7,MATCH($C2&"SOURCE_CLIENT",$C$2:$C$7&$A$2:$A$7,0)) press CTRL+SHIFT+ENTER