Columns with the same heading in a collection

[Anonymous]

Hi all Please can you help me with the best way of overcoming this system exception - 'A column named 'Normal' already belongs to the DataTable' I can't hardcode the column headers in to the collection as it varies from account to account. Some accounts could have just one header named 'Normal' whist another account might have 2 headers named 'Normal'. I export the data to Excel (they'll be 4 to 6 columns of data, occasionally with a duplicate column named Normal as described above) then import the Excel sheet in to a collection. Thanks in advance Jordan

[AndreyKudinov]

You will have to rename one column somewhere. It depends on actual process details - one or two columns always called ""Normal"" would have a simple solution, arbitrary number of duplicate columns with unknown names is a completely different case. For example, find Normal in headers in excel and rename to Normal1, Normal2 ...