Hi, I was wondering if it was possible to use Power Automate to unpivot certain columns of data? I have a massive file of data but I need to unpivot only certain columns. Is this possible. The steps are the following:
1. Extract a copy of the data from sharepoint (key word is copy - I do not want to edit the format of the original file)
2. Once file is open, extract the data from a certain sheet and only extract certain columns
3. Take the columns and unpivot the data (which I would the data transform function manually)
Is this at all possible? Let me know. Thanks!


Report
All responses (
Answers (