Hi Everyone,
Need to ask the expression to combine rows with 2 to 3 same column, i search in the community but they use noconcatinate but it is not use in expression
Expression to combine row that have 2 to 3 same column
FROM |
|
|
|
|
IMSPI CODE |
ITEM DESCRIPTION |
BATCH NO. |
PALLET NUMBER |
ENDING INVENTORY |
PF0970227 |
SENKA PERFECT WHIP 120G 21AW |
2234HD |
LA1001P-01 |
35 |
PF0970227 |
SENKA PERFECT WHIP 120G 21AW |
2234HD |
LA1001P-01 |
36 |
|
|
|
|
|
TO |
|
|
|
|
IMSPI CODE |
ITEM DESCRIPTION |
BATCH NO. |
PALLET NUMBER |
ENDING INVENTORY |
PF0970227 |
SENKA PERFECT WHIP 120G 21AW |
2234HD |
LA1001P-01 |
71 |