From column A and column B data into 1 line pair

[vutienhp]

Hello all!
I need a VBA Code to solve my problem as attachments.
Please see the file.
thank you!

Note: If Column B has a value of 0 is not paired

[MickG]

Try:-

Please Login or Register  to view this content.

Regards Mick

[Richard Buttrey]

Hi,

Enter this to C2, and copy it down. Then select C16, copy it and paste it back as a value.

Please Login or Register  to view this content.

[vutienhp]

Try:-

Please Login or Register  to view this content.

Regards Mick

Your answer so fast!
I want to ask you is that I want to delete the character "," at the end of the line you just created, then how?
thank you!

[vutienhp]

Hi,

Enter this to C2, and copy it down. Then select C16, copy it and paste it back as a value.

Please Login or Register  to view this content.

Thank you!
This may seem a long way, further still appear 0kg value in line pairing?

[Richard Buttrey]

Hi,

To avoid the zero use this modified formula in C2 copied down.

Please Login or Register  to view this content.

[MickG]

Try this:-

Please Login or Register  to view this content.

Regards Mick

[vutienhp]

Try this:-

Please Login or Register  to view this content.

Regards Mick

Standard!
thank you very much

[MickG]

You're welcome