Previous Topic Next Topic

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 Contributor 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

1 response

Answer 1 / 1
TrowaD Posts 2921 Registration date Sunday September 12, 2010 Status Contributor 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

Similar discussions

VBA column
sunilherode -
Ambucias -

2 responses
Can no longer paste text into insta
6hypnone -
Gordon -

7 responses
How do I extract specific data from a cell in excel?
mcat79 -
ac3mark -

5 responses
Root directory is full or errors during pasting
5468960 -
aryann9152 -

5 responses
Roots directory fulls or errors during parsing paste
Sanjay -
dwebb -

1 response