Pivot table in power query

[deniztopcu]

topic closed

[AliGW]

There are instructions at the top of the page explaining how to attach your sample workbook (yellow banner: HOW TO ATTACH YOUR SAMPLE WORKBOOK). Screenshots are of little practical use as we cannot manipulate them.

A good sample workbook has just 10-20 rows of representative data that has been desensitised. It also has expected results mocked up, worked examples where required, relevant cells highlighted and a few explanatory notes.

[Pepe Le Mokko]

As external links are potentially unsafe, please post your sheet on the forum. thx

[deniztopcu]

Thank you for your warning. I have attached the file to the page.

[JeteMc]

I feel that we might be better able to help, If we had a more complete explain of what you want.
It might be helpful to write the explanation in Turkish and then use an online translator to convert the request to English.
Let us know if you have any questions.

[deniztopcu]

How could it be more open?
When uploading to excel, I am uploading it with the pivot table report.
This "pt report"; Is it possible to do it inside a power query?
I know this is not possible for multiple column headers.
Is there a solution with more Advanced codes?

[AliGW]

How could it be more open?

Please don't take this tone with our members, who are both highly experienced and well-versed at answering questions. If they ask for more detail, give it. The help you get here is given voluntarily: don't be surprised if your last response makes some of your helpers decide not to bother helping with your request.

[deniztopcu]

What can I give more details, I have a picture explanation and an excel file.
Nobody writes a single line about the answer, but not everyone gives an answer other than "I don't understand, I don't understand".
Don't insert Excel this way, report crosslinking.
No, I will not report crosslinking.
I would like to see answers from different names in different forums that do not affect each other.
And a simple solution in one forum may not even be answered in the eyes of the other forum. or vice versa.

[AliGW]

Administrative Note:

We would very much like to help you with your query, however it has been brought to our attention that the same query has been posted on one or more other forums and you have not told us about this. You are required to do so.

Please see Forum Rule #3 about cross-posting and adjust accordingly. Read this to understand why we (and other sites like us) consider this to be important: https://excelguru.ca/a-message-to-forum-cross-posters/

(Note: this requirement is not optional. No help to be offered until you provide a link or, for members with fewer than 10 posts, a comment telling us where else you have posted this query.)

[alansidman]

You obviously have not read why every forum asks for you to tell when you crosspost. Read this to help you understand: https://excelguru.ca/a-message-to-forum-cross-posters/

You have posted in two forums and in both no one who has answered can understand your issue. If you continue with not adding additional information to help us to help you and if you continue with an "attitude" then you will find yourself banned from posting in this forum. You have been warned. Be respectful and comply with our forum rules and supply the necessary information needed to get the assistance you require.