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.
Solved! Go to 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.