Combining two cells that have lists in them

1

Hi,

I have a document where I am trying to combine two cells that have lists in them. I need the Vendor column and the item name column to combine into one . For example, the Vendor and Product Name column for order 1893 needs to look like this

Cheeta 2018 L 1 - Made to Order / CX- 79 Pure White, Cheeta 2018 L 2 - Made to Order / CX- 79 Pure White, etc

Not like this. Which is the only way I have been able to combine them so far.

Cheeta,Cheeta,Cheeta,Cheeta,Cheeta,Cheeta,Cheeta,Cheeta,Cheeta,Cheeta,Cheeta,Cheeta,Cheeta,Cheeta,Cheeta,Cheeta,Cheeta,Cheeta,Cheeta,Cheeta,Cheeta,Cheeta,Cheeta,Cheeta,Cheeta,Cheeta,Cheeta,Cheeta,Cheeta,Cheeta,Cheeta,Cheeta,Cheeta,Cheeta,Cheeta,Cheeta,Cheeta,Cheeta,Cheeta,Cheeta,Cheeta,Cheeta,Cheeta,Cheeta 2018 L 1 - Made to Order / CX- 79 Pure White,2018 L 2 - Made to Order / CX- 79 Pure White,2018 L 3 - Made to Order / CX- 79 Pure White,2018 L 4 - Made to Order / CX- 79 Pure White,2018 M 2 - Made to Order / CX- 79 Pure White,2018 Meg 3 - Made to Order / CX- 79 Pure White,2018 Meg 4 - Made to Order / CX- 79 Pure White,2018 Meg 5 - Made to Order / CX- 79 Pure White,2018 Meg 6 - Made to Order / CX- 79 Pure White,2018 S 1 - Made to Order / CX- 79 Pure White,2018 S 2 - Made to Order / CX- 79 Pure White,2018 XL 1 - Made to Order / CX- 79 Pure White,2018 XL 2 - Made to Order / CX- 79 Pure White,2018 XL 3 - Made to Order / CX- 79 Pure White,2018 XL 4 - Made to Order / CX- 79 Pure White,2018 XL 5 - Made to Order / CX- 79 Pure White,2018 XL 6 - Made to Order / CX- 79 Pure White,2018 XL 7 - Made to Order / CX- 79 Pure White,2018 XL 8 - Made to Order / CX- 79 Pure White,2018 XS 1 - Made to Order / CX- 79 Pure White,Galatea - Made to Order / CX- Other- Specify in Notes,Helios - Made to Order / CX- Other- Specify in Notes,Kaly Calcite Mega 1 - Made to Order / CX- Other- Specify in Notes,Kaly Tufa L1 - Made to Order / CX- 7 Sky Blue,Kaly Tufa L3 - Made to Order / CX- 7 Sky Blue,Kaly Tufa M1 - Made to Order / CX- Other- Specify in Notes,Kaly Tufa Mega - Made to Order / CX- 7 Sky Blue,Kaly Tufa Mega - Made to Order / CX- Other- Specify in Notes,Kaly tufa XL1 - Made to Order / CX- 7 Sky Blue,Kaly tufa XL1 - Made to Order / CX- Other- Specify in Notes,Miranda - Made to Order / CX- Other- Specify in Notes,Thalassa - Made to Order / CX- Other- Specify in Notes,Triton - Made to Order / CX- Other- Specify in Notes,Urban L1 - Made to Order / CX- Other- Specify in Notes,Urban L2 - Made to Order / CX- Other- Specify in Notes,Urban L3 - Made to Order / CX- Other- Specify in Notes,Urban L4 - Made to Order / CX- Other- Specify in Notes,Urban M1 - Made to Order / CX- Other- Specify in Notes,Urban M2 - Made to Order / CX- Other- Specify in Notes,Urban M3 - Made to Order / CX- Other- Specify in Notes,Urban S3 - Made to Order / CX- Other- Specify in Notes,Urban XL1 - Made to Order / CX- Other- Specify in Notes,Urban XS1 - Made to Order / CX- Other- Specify in Notes,Urban XS2 - Made to Order / CX- Other- Specify in Notes

Any help is appreciated!

2

Hello @Canon_Huse!
Instead of extracting each value separately and concatenate, you should concatenate by each item, this can be accomplished with the FormulaMap() formula, that iterates for each value on a list in this case Order.LineItems.
Give this formula a try:

thisRow.Order.LineItems.FormulaMap(
  Concatenate(
    CurrentValue.Vendor,
     " - ",
    CurrentValue.Name
  )
)

image
image927×440 15.7 KB

2 Likes
3

That did the trick! Thank you so much!

1 Like