here is a sample of the data with nonsense numbers in it. We want to copy and paste it as values only but also keep the grouping on the rows. If i do paste special values only and then do formats too it only keeps the grouping along the top. Rather frustrating!Sample.xlsx