Formula Help Please

[Jfloyd80]

Hi,

I was wondering if there was a formula that could automatically duplicate the first KeyLetter for each row until it changes then repeat?

ITEM LETTERKEY LETTERKEY DUPE
Item 1 A A
Item 2 A
Item 3 A
Item 4 B B
Item 1 B
Item 1 C C


Thanks!

 

[Joe4]

You are welcome.