How to repeat name and id# to blank row

**pay227** · 09-27-2019, 05:12 PM

Hello Excel Gurus! I have converted a file into excel but I need help on how to get the name and id# repeat for each blank row per employee. Can someone please help? Thank you

Please see attached file

**protonLeah** · 09-27-2019, 05:22 PM

Title updated

**protonLeah** · 09-27-2019, 11:34 PM

Please Login or Register  to view this content.

**pay227** · 10-18-2019, 01:33 PM

Thank you so much! This is great!

I was trying to see where I can get the formula so I can use for certain fields. Please see attached file. I would like to copy the highlighted data in column C and D to column S,T,U,V and fill in the blank lines as it goes down. Hope this is doable. Is that a macro you created?

**JeteMc** · 10-23-2019, 11:29 AM

This request differs enough from the original that it is probably deserving of its own thread (for future reference).
Once the macro is activated and columns A:B are filled the following formulas may be applied to columns S:V
Columns S and U are populated using formulas similar to: =IF(B2="","",IF(B2<>B1,C2,S1))
Columns T and V are populated using formulas similar to: =IF(S2="","",INDEX(C$2:C$85,AGGREGATE(14,6,(ROW(C$2:C$85)-ROW(C$1))/(B$2:$B$85=B2)/(C$2:C$85<>""),1)))
Let us know if you have any questions.