Hi,
I have a table that has two columns, Country and Part Code. I want to change the layout so that I get a separate column for each country that contains the part codes relevant to the country.
I thought that using pivot column and selecting "don't aggregate" in the advanced options would do this but when I try I am getting the correct column headers but only one row which shows "error". The error message is as follows:
Expression.Error: There were too many elements in the enumeration to complete the operation.
Details:
I have attached a file containing the table.
Thanks
Bax
Hi Bax,
The problem can be fixed by first adding an index column before pivoting. However, that will give you a stepped result, which I doubt you want. Please see this tutorial that was published in our newsletter last week that has a solution.
Mynda
