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 lengths for each tenth inch on a different sheet, but I dont know of any functions that would copy or show a cells value, and I also dont know how to then prevent that cell from being copied again
3 Replies
- 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)
