Previous Topic Next Topic

Pasting a column into alternating rows in new column

Kusay - Jul 4, 2022 at 05:27 AM
TrowaD Posts 2921 Registration date Sunday September 12, 2010 Status Moderator Last seen January 16, 2023 - 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 reply

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

Hi Kusay,

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

Best regards,

Trowa
0

Similar discussions

VBA find column by name and sort
SidK -
bOFILL -

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

5 responses
Converting rows of data in notepad to columns
Need help -
Philgood_FR -

2 responses
Auto generate serial number in excel based on input value
Raj -
Raj -

14 responses
Counting number of times a value appears if..
jensorr -
sambr22 -

7 responses
converting rows data into columns on conditon
gd -
RWomanizer -

3 responses