Forum Discussion
Transposing Data
Hi All, I have seen other posts regarding transposing rows and columns, but none that match my specific circumstance. The current structure of my data table is as such: Column 1 Column 2 C...
I also shortened the steps (optimized, not much)
Anonymous So what would the final result look like fully from the example given?
The issue stems from this: the first 3 rows have a unique structure where the first column is null, the second column is really a column header, and then each remaining column has 1st row Retailer ID, 2nd row Prod Code, 3rd row Product Description with all rows underneath representing the quantity sold for that unique item at the specified country and date in columns 1 and 2.