Hello,
I need help with a file for which I would like a workflow that performs the following:
1. Values in the Accounted Net are distributed into columns. The distribution should be grouped in columns following the categories listed in column E. As a result, for example, all values for TP collection will be allocated under this category.
Here is a picture of source file
The result I want is easily achieved using excel and I would like to see a workflow that shows the following.
2. After the distribution is performed, I want to take the resulting file and distribute the data into different tabs. The distribution should be done based on the GL accounts, so tabs are created in the same file for GL accounts 200000, 201000, 201100, etc.
I am attaching a reduced file to help with the workflow.
Source tab - initial data
results - distribution based on categories
Individual tabs - distribution of the results based on the GL account.
Thanks and look forward to guidance.
Solved! Go to Solution.
Thank you.
This is what I needed and it works when I entered the original files
Nayade1