CODEWITHSUNDEEP
excelexcel-formulalookup
Matelutex
Matelutex

Reputation: 2220

Excel - copy values from one column to another

I have 2 columns in my excelsheet:

enter image description here

I have another 2 columns in the same excelsheet:

enter image description here

I want to fill the second table (first screenshot) with values from the second screenshot (second column) and join by the first column (values like AA.....). How to do that? One value, for example AA14425088 occurs 2 times so in my second column in first screenshot have to be 2 values (separated by comma ",") like:

Upvotes: 0

Views: 2083

Answers (1)

L. Scott Johnson
L. Scott Johnson

Reputation: 4412

Build up the desired string in the second screenshot by adding another column that concatenates the strings (bottom-up) in the second column if the strings in the first column match:

C1:

=IF(A2=A1,B1&","&C2,B1)

Then VLOOKUP() on that

Upvotes: 1

Related Questions