hI All,
Solution enhanced (after see official solution), I keep my logic of my first solution but not make mistake in my
I don't use the files product details because in the first files we have product SKU used in the order then we ccan check in the files product catergories to search the catergory of each SKU.
No use of "Transpose" or "Cross Tab" for this solution. I use only "2 "Find and Replace" , 1 "Text to Column", 1 "Summarize" and 1 "Forrmula"