[FONT="]Hi![/FONT]
[FONT="]
[/FONT]
[FONT="]I have a data source that is giving me data as values that is organized like a pivot table (with both rows and columns... if it was just rows it would be an easy task).[/FONT]
[FONT="]
[/FONT]
[FONT="]Is there a way I can turn this into a pivot table (not values) so I could play around with the fields? If I could turn this into a standard data source that would be helpful. Including below a screenshot which shows what i'm dealing with.[/FONT]
[FONT="]
[/FONT]
[FONT="]Here is an example of what my data source is like (just way bigger than this example):
[/FONT]
[FONT="]https://drive.google.com/open?id=10YseEeOmsRZAatLatTDY4qyUInFoMWwp[/FONT]
[FONT="]
[/FONT]
[FONT="]Here is an example of converting the table manually into a simple data table. I basically need to find a way to do this on mass scale and not manually:[/FONT]
[FONT="]https://drive.google.com/open?id=1dt1XJ4RQ_AcO9IKAW9HFXqEsnZkCoCvF[/FONT]
[FONT="]
[/FONT]
[FONT="]Here is an example of actual pivot using the data I manually updated:[/FONT]
[FONT="]https://drive.google.com/open?id=16w_I7dWwt5yTHRdSXCk3me7Gi0AoAtr4[/FONT]
[FONT="]
[/FONT]
[FONT="]
[/FONT]
[FONT="]Anyone that could help?[/FONT]
[FONT="]
[/FONT]
[FONT="]Thanks[/FONT]
[FONT="]
[/FONT]
[FONT="]I have a data source that is giving me data as values that is organized like a pivot table (with both rows and columns... if it was just rows it would be an easy task).[/FONT]
[FONT="]
[/FONT]
[FONT="]Is there a way I can turn this into a pivot table (not values) so I could play around with the fields? If I could turn this into a standard data source that would be helpful. Including below a screenshot which shows what i'm dealing with.[/FONT]
[FONT="]
[/FONT]
[FONT="]Here is an example of what my data source is like (just way bigger than this example):
[FONT="]https://drive.google.com/open?id=10YseEeOmsRZAatLatTDY4qyUInFoMWwp[/FONT]
[FONT="]
[/FONT]
[FONT="]Here is an example of converting the table manually into a simple data table. I basically need to find a way to do this on mass scale and not manually:[/FONT]
[FONT="]https://drive.google.com/open?id=1dt1XJ4RQ_AcO9IKAW9HFXqEsnZkCoCvF[/FONT]
[FONT="]
[/FONT]
[FONT="]Here is an example of actual pivot using the data I manually updated:[/FONT]
[FONT="]https://drive.google.com/open?id=16w_I7dWwt5yTHRdSXCk3me7Gi0AoAtr4[/FONT]
[FONT="]
[/FONT]
[FONT="]
[/FONT]
[FONT="]Anyone that could help?[/FONT]
[FONT="]
[/FONT]
[FONT="]Thanks[/FONT]