I have data that has been filtered into a pivot table from multiple sources. This table consists of 3 columns, I will need to automate a process of copying this data from a range which can change dynamically in size depending on future entries, and I wish to paste into a separate consolidated two column range elsewhere in the worksheet. The issue I'm having is column A and Column B have labels which all correspond to figures in Column C. Column A starts in row 5 but will show a "(blank)" after several labels, this will change over time but always begin at 5, and once that "blank" label is found, the list will continue in column B in the following row. Again all data will remain constant in the third column, but I need to consolidated columns A and B correctly until column B data ends. Hopefully that's clear. Thanks in advance!