I have moved my data from one sheet to another via VBA. I want to use tableau to visualise the data. But it can only read the data if it is horizontal. I need the year to loop it self and then insert the data next to it as shown in below picture. I have added the code that i use to move data, in the last part if needed. I need to make this possible via VBA and not using the transpose function.
The picture is an example of what i would like it to look like.. "the result i seek" as linked below
https://imgur.com/a/Pgq2I7l
The picture is an example of what i would like it to look like.. "the result i seek" as linked below
https://imgur.com/a/Pgq2I7l