LinkBack URL
About LinkBacks
Hi
Please see attachment- Go to Sheet 2
Under the Name column if I filter Limontas, Anna, only column with data are shown, what should i do to stop the column from not collapse, i want to show the column even thou it maybe empty
Thanks
Hi
Please see attachment- Go to Sheet 2
Under the Name column if I filter Limontas, Anna, only column with data are shown, what should i do to stop the column from not collapse, i want to show the column even thou it maybe empty
Thanks
Hi ziyan,
When you pivot your data the "Study" rows are added together if they are equal. I think you are trying to do a simple Filter instead of a Pivot. See the attached on Sheet1 where I'm using AutoFilter to show what I mean.
Filtered Table vs Pivot Table.xlsx
One test is worth a thousand opinions.
Click the * Add Reputation below to say thanks.
Format the column field to show Items with no data
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks