I want to convert columns data to rows in my goggle sheets. Please help me to do this using melt function using jupyter notebook. Also I want updated sheet to be inserted in the same google sheets link but as a new tab. Is there any way to do that?
Asked
Active
Viewed 132 times
0
-
How do you imagine an answer to the question? Please add the data and your expected outcome. – bitflip Oct 29 '22 at 18:51
-
It's likely easier to use [pivot tables](https://support.google.com/docs/answer/1272900?hl=en&co=GENIE.Platform%3DDesktop) within google sheets. The Google Sheets API is very annoying to use. – Nick ODell Oct 29 '22 at 18:54