Notifications
Clear all
Topic starter
i have a raw data with duplicate items, there is any option to remove duplicate items automatic and report should be as per column wise.
| B/e No | Date | a | b | c | d | e | f | g |
| 2909736 | 25-02-2021 | 11 | 12 | 13 | 14 | 16 | 18 | 19 |
Posted : 07/10/2022 9:05 am
Hi Saliha,
You can use COUNTIF to add a count of the B/e No records and then use a PivotTable to get your layout. See attached.
Mynda
Posted : 08/10/2022 11:10 pm
Topic starter
Hi Mynda
there is duplicate item possible to way remove this duplicate data.
Posted : 11/10/2022 1:58 am
