PIVOT TABLE is a well known feature of EXCEL which everybody of us might have heard of. But many times we don’t know how to effectively use the PIVOT TABLE.
PIVOT TABLE is a dynamic table which we can create in Excel. We called it dynamic as we can transform it within seconds. The original data remains the same.
We know that whatever is hinged to a pivot, can rotate here and there, so is the name given to these tables.
PIVOT Table is a very powerful tool to summarize, analyze explore the data in very simple steps. Its very important to learn the use of pivot tables in excel if we want to master excel. Pivot tables give us the facility to put different simple operations on a selected data in seconds.
We have already learnt about PIVOT TABLES HERE.
In this article we will focus upon the frequent difficulties which users face while using the pivot tables.
It is really easy to change the layout of the pivot table.
After we have created a pivot table, many times we need to change the layout of the pivot table.
LAYOUT OF THE PIVOT TABLE means to rearrange its rows and columns etc. to different positions as per our requirements.
Let us see how we can change the layout of the pivot table.
For the example we take a table which we have already pivoted.
STUDENT ID NO. REMARKS AMOUNT DAVE 12 A 12000 KABIR 13 A 13000 HELEN 14 B 11000 NAVAM 15 B 23000 POONAM 16 B 21000
In the table shown above, let us try with the simple operation of changing the position fields.
Let us try to put the AMOUNT COLUMN in the center.
It is so frequent in Excel when we play with the rows and columns while working with our sheets. But is it so easy?
We have to cut the Row and then adjust it somewhere else. With this, we need to keep in mind that our formulas should be intact and there should not be any problem with them. Similar is the case when we need to shift or delete or insert any new column. But in PIVOT TABLES, we can do that in a snap. That also without worrying about the formulas.
In fact, in pivot tables we need to just worry about the initial data, so that Excel doesn’t find hard to pick the data, rest PIVOT TABLE does everything.
So let us find out how we can add or remove any row or column in a PIVOT TABLE in Excel.
NOTE: IF WE CHOOSE THE COMPLETE TABLE AND PASTE IT, IT WILL PASTE THE COMPLETE TABLE IN THE PIVOT FORM ONLY.
OTHER WAYS TO REACH THIS ARTICLE
YOU MAY LIKE