how to merge many cell to one cell with keeping all data

V

Valley

Dear all,

I meet a question about following.
in A column, there are many data(some data are same), and in B column,
there are many relevant data, but they are different, how to merge all
the revelant data to one cell in B column with the same in A column,
thanks in advance!

For example

A B
123 R1
123 R2
123 R3
123 R4
124 L1
124 L2
124 L3
125 C1
125 C2
. .
. .
. .


BR
Valley
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

how to merge many cells to one cell with keeping all data 4
Dealing with the error: unable to filter on excel hc home school 0
Formula to fill one cell from another 0
Word Mail Merge - keeping paragraph breaks that appear in original Excel cell data 2
VLOOK with Index - How to get results across instead of down? 3
Close Match 5
Compare 2 reports and merge data to third report 0
adding moving decimals in more than one cell 0

Top