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

Tonald loke
How to delete a column in word - Guide
Excel count occurrences of string in column - Guide
Excel column to number - Guide
Tweetdeck expand column - Guide
Insert a new sheet at the end of the tab names and paste the range names starting in cell a1. autofit columns a:b and name the worksheet as named ranges. ✓ - Excel Forum

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

Can no longer paste text into insta

Root directory is full or errors during pasting

Roots directory fulls or errors during parsing paste

Root directory is full or has another unknown error

VBA find column by name and sort

Similar discussions

Subscribe To Our Newsletter!