Why do we observe duplicate/multiple rows for the same supplier when downloading the supplier grid from the WarRoom?

Created by Rohit Sawant, Modified on Mon, 25 Aug at 3:53 PM by Rohit Sawant

The presence of duplicate or multiple rows for the same supplier in the downloaded supplier grid is due to the way the data is displayed and formatted in the WarRoom.
On the WarRoom listing page, when multiple values exist for a specific column (e.g., emergency contacts), they are shown as comma-separated values for a single row, representing the supplier.
For example, if the portal indicates that a supplier has more than one emergency contact, it will display all the contacts in a single row with comma separation.
However, when downloading the supplier table grid, the downloaded sheet treats each contact as a separate row for that particular supplier.
Consequently, if a supplier has five contacts, the downloaded sheet will show five rows for that supplier, each row representing an individual contact.
This condition applies to all columns under the supplier table grid that contain comma-separated values.
As a result, when downloading the grid, it may lead to the appearance of multiple rows for the same supplier, corresponding to the various values within those columns.