Hi all,
Is it possible to create a pivot with multiple columns?
I have already found several posts but no solution leads to the correct output.
Raw Data
Pivot in Excel
Did any of you already had the same problem or does anyone know a post that solves such a problem?
Thanks for any help!
Best wishes
Max
Thanks a lot for your answer.
I do not need the function to hide anything. It would be enough if I have a hardcopy of the table.
Is this also not possible?
Hi @Max90
Can you provide some sample input and expected output it will help us get a better understanding of the usecase.
Hi @Max90
Kudos on finding the solution.
This is one of the hectic usecases. If you are getting the expected output you should be good 🙂
Hi @atcodedog05
I found one mistake in my workflow. Maybe you can help me to solve it. See the attached Screenshots for my problem. The last select tool on my workflow do not change automatically if more lines are in the input file. If there is for example one more line, F9 would be created and should also be selected. In other words I need a option to select always all Fields with F plus Account and Balance at the beginning.
Is my problem understandable?
I also uploaded a new version of my workflow (one formula tool was missing)
Thanks a lot
Max
Select tool: