“In data processing, a pivot table is a data summarization tool found in data visualization programs such as spreadsheets or business intelligence software. Among other functions, a pivot table can automatically sort, count, total or give the average of the data stored in one table or spreadsheet.”

* 엑셀 : 삽입 ▷ 피벗 테이블 _ 데이터 분석 집계