Dear Excelforum members,

I am trying to create a set of sequences based on a column running like this

1001 I am then looking to build a sequence 100101
1001 by adding "01, 02..nn" untill the number in column A 100102
1001 changes and then the numbers starts again 100103
1002 100201
1002 100202
1002 100203

Any suggestions are much appreciated

Column A Column B
1001 100101
1001 100102
1002 100201
1002 100202
1003 100301