Meropi, something turned up yesterday in the Google Docs forum that may be able to help you. Someone wanted to transpose several sheets but keep them grouped by date and an ID number - https://productforums.google.com/forum/#!topic/docs/PxWFYY3BKjg;context-place=forum/docs
The solution is a little complicated as it's pulling data from several pages, but what it's doing is using a single ARRAYFORMULA and VLOOKUP to rewrite the tables. You can see in https://docs.google.com/spreadsheets/d/1pZOyuC9NKkvcOc-kNAF7RJCqHz2Oddj8Kd_rlPjjWm0/edit#gid=919009111 (columns K to N) where they used TRANSPOSE to rearrange the original data, but Matt King's solution in https://docs.google.com/spreadsheets/d/1pZOyuC9NKkvcOc-kNAF7RJCqHz2Oddj8Kd_rlPjjWm0/edit#gid=521868215 uses a single formula to get everything done. If you want to use a version of that to write to different Sheet without creating an intermediate table in the original then you still need to use IMPORTRANGE to access it - https://www.ablebits.com/office-addins-blog/2017/07/05/vlookup-google-sheets-example/ -- You received this message because you are subscribed to the Google Groups "Google Visualization API" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. To post to this group, send email to [email protected]. Visit this group at https://groups.google.com/group/google-visualization-api. To view this discussion on the web visit https://groups.google.com/d/msgid/google-visualization-api/4ff57b7a-6189-4575-b6a1-9b561fe5875e%40googlegroups.com. For more options, visit https://groups.google.com/d/optout.
