Pasting a column into alternating rows in new column

Closed
Kusay - Jul 4, 2022 at 05:27 AM
TrowaD Posts 2921 Registration date Sunday September 12, 2010 Status Moderator Last seen December 27, 2022 - Aug 16, 2022 at 11:44 AM
Hello, i have a column of ID numbers and a column of names next to it, I want to copy and past the names with their corresponding id in cell under them in 3rd column
Example:
210300 ronald brown ronald brown
210267 tonald loke 210300
tonald loke
210267



System Configuration: Windows / Chrome 103.0.0.0
Related:

1 response

TrowaD Posts 2921 Registration date Sunday September 12, 2010 Status Moderator Last seen December 27, 2022 555
Aug 16, 2022 at 11:44 AM

Hi Kusay,

You can try a formula like: =A2 & " " & B2

Best regards,

Trowa


0