This site uses different types of cookies, including analytics and functional cookies (its own and from other sites). To change your cookie settings or find out more, click here. If you continue browsing our website, you accept these cookies.
I get the same info but the columns are not in the same order, but I cannot find any rhyme or reason to the column order of the answer. I suppose I could manipulate the order of the answer, but that seems pointless (and kind of like cheating)
Process: - Concatenate Category, Subcategory, and Description (allowing for nulls in the Subcategory) - Transpose data in lower thread - Join data - Sort results by Name (not needed but part of my heroically feeble attempt to match the answer column order - Cross-tab back - Dynamic rename (since cross-tab seems to add underscores) to replace Header - Remove unneeded column