help with the formula

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have few serial numbers where in I need to connet for some of the line
items I have in my spreadsheet.

For Eg: If I have 123 as serial numbers and I have 3 items to connect.
Three items are a.5685 b. 9000 c. abcd.

The result should come as
Serial# Line item
123 5685
123 9000
123 abcd

This is how it should look.

I have nearly 6000 line to do like this.
 
One guess ..

I'll presume this is your source table (not the result said:
Serial# Line item
123 5685
123 9000
123 abcd
Click to expand...

Place in C2: =A2&"-"&B2
Copy C2 down. Replace the dash: "-" in the formula with your desired separator

---
 
Back
Top