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

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

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
Root directory
Gurmeetsingh -
ac3mark -

1 response
Creating a Batch File to copy a directory
Waqas -
BB -

14 responses