Workflow to allocate data

[Nayade1]

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.

[Tyro_abc · Accepted solution]

hi

Does this work for you?  You have to enter source file and target file location.

Here is the settings for output excel file.

Regards

Arundhuti

[Nayade1 · Accepted solution]

Thank you.

This is what I needed and it works when I entered the original files

Nayade1