Data Manipulation Question

[FECL3]

Hi 

I've used a dynamic input tool to input data from many different tabs that relates to a different class. It has input similar to Column A to F in the attached Sheet.

I want to transpose the data so that the class runs down the side adjacent to the Quarter, but only to the values of which relate to that particular class.

I have attached a sheet which shows the intended input versus the desired output.

Any help would be much appreciated. 

[Blake · Accepted solution]

Hi @FECL3 

Check out the attached workflow to accomplish what I think you're looking to do. 

You'll probably also want to check the box in option #6 of the input data tool - "First row contains data" so that you have generic, location based field headers.

[messi007]

Hello @FECL3 ,

Below the workflow

Attached the workflow as well,

Hope that helps!

Regards,