I have two tables.
First table with duplicate material numbers and an ‘NR2’ Column
and the second table with only 1 material number and also an ‘Nr’ Column.
I need to display the ‘NR2’ from the first table ‘Export’ in the ‘overview’ table, but only the most recent (don’t have a date). The last letter should be copied into the second table ‘overview’. Each material number should have 2 letters at the end, hope the picture explains it. Thanks!
Export table:
| Material | NR 2 |
|---|---|
| 123 | X |
| 123 | Y |
| 123 | Z |
| 456 | K |
| 456 | L |
| 456 | M1 |
| 789 | – |
| 789 | A |
| 789 | D |
Overview table: NR 2 does not have to be the same number as NR 1
| Material | NR 1 | NR2 From Export |
|---|---|---|
| 123 | X | Z |
| 456 | K | M1 |
| 789 | D | D |
New contributor
Marco is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.