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...
I expect a Pivot Table should do the trick.
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)