I've tried a pivot table, but since I have more than one column i can't get it to hide blanks in one column without hiding the fields in the adjoining column, short of adding a new pivot table in each column.
I've attached a sample of what I'm working on. My complete file will have 10-15,000 rows of data.
Sheet 05PDCH where the pivot table pulls the info from Sheet Data, columns B and C populate depending on the value in column A.
I want the Sheet Work to Process to enter the values from those columns B and C, removing blanks. (as in the static sample on that sheet)
Bookmarks