Pamella
08-25-2019, 08:15 PM
In Column B I have names with Id's underneath. I need to add the names in Column A, via macro.
COL B
"Smith"
TH123
12334
REBBB
56322
43433
"Jeffs"
65433
223344
212311
123
"Randal"
W2123
TRSDS
Col A Col B
Smith
Smith TH123
Smith 12334
Smith REBB
Smith 56322
Smith 43433
Jeffs
Jeffs 65433
Jeffs 223344
Jeffs 212311
Jeffs 123
Randal
Randal W2123
Randal TRSDS
COL B
"Smith"
TH123
12334
REBBB
56322
43433
"Jeffs"
65433
223344
212311
123
"Randal"
W2123
TRSDS
Col A Col B
Smith
Smith TH123
Smith 12334
Smith REBB
Smith 56322
Smith 43433
Jeffs
Jeffs 65433
Jeffs 223344
Jeffs 212311
Jeffs 123
Randal
Randal W2123
Randal TRSDS