Combine 2 Columns from 2 different sheets with keeping duplicates

[Sekars]

Hello Friends

Please find the attached excel file.

I need to combine the columns in 2 Sheets (Sheet 1 and Sheet 2 in Sheet3)

Results hardcored in Sheet3 in light yellow cells need to be plot by formula.

thanks in advance

[Richard Buttrey]

Is this something you want to do many times in which case a macro may be best, otherwise just copy and pate one list under the other and renumber.

[Sekars]

By using formula, just copy one under the other.

[JohnTopley]

In Sheet3

in C4

=IF(ROWS($1:1)<=COUNT(Sheet1!$A$4:$A$25),INDEX(Sheet1!C:C,ROWS($1:4)),INDEX(Sheet2!C:C,ROWS($1:4)-COUNT(Sheet1!$A$4:$A$25)))

copy across and down

[Sekars]

Hello John

Thank you

This is my exact requirement, i test it in my real application from the sample model attachment. it is working fine.

Thanks again.

[JohnTopley]

You're welcome.

Thank you for the feedback and rep.

[Sekars]

Hello John

hanks for your reply, your formula saved my lot of repeated manual work

thanks