ROK
01-25-2013, 06:19 AM
I am going nuts trying to figure this out, I looked a transpose and Test to Columns and just know its something straight forward and I'm just not searching with the right questions.
I have 2 Columns of Data 1. [Location ID] 2. [Product ID] and I want to show a unique [Location ID] with the [Product ID] expanded across the single row With 4 New Column Headings and then if possible sort each row under the new Product ID Headings in descending order. Not clear I know but hers is a sample of what I mean. Any help would be greatly appreciated
Please See Attached for Before and After Examples:
I have 2 Columns of Data 1. [Location ID] 2. [Product ID] and I want to show a unique [Location ID] with the [Product ID] expanded across the single row With 4 New Column Headings and then if possible sort each row under the new Product ID Headings in descending order. Not clear I know but hers is a sample of what I mean. Any help would be greatly appreciated
Please See Attached for Before and After Examples: