Forum Discussion
Show weight on different sheet and align with specified length
I have a raw data sheet that has columns for length and weight. Weights were only recorded for a subsample, specifically, each tenth of an inch has up to 4 weights. I want to show each of those 4 l...
My pivot table knowledge is limited, so I'm not sure how to transform 1 column of weights into 4 columns, Weight 1-4, and how to simply display them, not perform some sort of calculation. I am also restricted because I can not alter how length is displayed in the Length Data image.
Drag the name of the Weights column to the column area of your pivottable (inside the taskpane which shows if you click anywhere in the pivottable)