Aug 18 2023 07:06 AM
Hello Sirs good morning, I have raised some Pivot Tables that originate from 2 sheets of the same file. I have tried to link the Reports or relate them so that my Data Segmentation allows me to work with all the information, but it has not been possible.
I have an iMac and the Data Tools options, Pivot for example, indicate that they are only available to Microsoft.
So what can I do about it?
Regards
Aug 20 2023 07:37 AM
You can use Power Query on an iMac to combine and transform data from multiple sheets within the same Excel file. Power Query is a powerful data transformation tool that is available in both Excel for Windows and Excel for Mac. It allows you to create queries to import, transform, and load data from various sources, including multiple sheets within the same workbook.
Here is how you can use Power Query to combine data from two sheets on an iMac:
Power Query offers a lot of flexibility in terms of data transformation and merging. It's a powerful tool that can help you create complex data workflows even on an iMac.
Keep in mind that the terminology and user interface might vary slightly between Excel on Windows and Excel on Mac, so make sure to refer to the Excel for Mac documentation or online tutorials specific to your version of Excel.
My knowledge of this topic is limited, but since no one has answered it for at least one day or more, I entered your question in various AI. The text and the steps are the result of various AI's put together. Therefore, I have this solution proposal for you.
My answers are voluntary and without guarantee!
Hope this will help you.
*If you liked my answer, please like this one.
If my answer helped, please mark it as the correct answer.
This will help several users here.