Is there any way in Altium to display/combine the different Variant configurations in a single Excel sheet exported from the Bill of Materials, e.g. have the different variant configurations displayed in different columns sharing the same rows for common components?
So far I have managed to create a BOM from my different variants in different Excel sheets that are grouped via our company item number for each specific component. I then had to manually combine the different columns into a single work sheet. However I found this to be very tedious and error prone. Thus I turned to one of the Excel forums to ask if this was able to be done via some macro. Fortunately they wrote back to me and gave me the following
However it would be much easier if I could do this directly somehow from Altium - does anyone know how?