Hi Everyone,
I need to copy data from a pivot table and paste it into an Excel sheet where permanent headers are present. The challenge is that the pivot table may not always have the same headers. For example, in the snapshot below, the table has four headers: Apple, Ball, Cat, and Dog. However, sometimes the pivot table may not include the "Cat" header. In such cases, I need to copy and paste the data while leaving the "Cat" column empty. How can I achieve this in powerautomate desktop flow ?
Best Regards
Ahmed
