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

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

Hi Kusay,

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

Best regards,

Trowa
0

Similar discussions

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

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

1 response
Root directory is full or has another unknown error
S94sourav -
jess -

4 responses
Corel Draw: Error Reading file problem
clinton_fields2 -
clinton_fields2 -

2 responses
Removing write protection using Diskpart
Alliancepotato -
NhuiSG -

13 responses