I am looking to see how I can capture the numbers of 5, 4, 3, 2, and 1's in columns AJ thru AO. However, columns (AJ & AK) needs to be combined and column (AL & AM), and (AN & AO) respectively. Right now I have to do a pivot table to capture this information. My process is to copy and paste for example column AK under AJ prior to doing the pivot table and then AL and AM and so on. Is there a macro that can be written with a button that can automatically capture this information upon request? Please note that because I am copying column AK (site B) underneath column AJ (site A) the pivot table picks up the name for site A and so on. Attached are the spreadsheet and an example of desired outcome?