Hi. Can somebody help with a formula? As per file attached, I need to extract the values from each row from sheet 1 into a column on sheet 2 but also to keep showing the group number for each value apart. I was able to do that by selecting the values from one row, copy and paste them on sheet 2 with special paste "paste transposed" but, this operation is take to much time and the file I have has more than 100 columns and more the 200 rows. I need to have on a different sheet (2) on column B, all the values per row, starting with column B until the end from sheet (1) and on column A, all group numbers from sheet (1) column A accordingly to the value. Thank you Meropi
-- 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/3b1737b9-2930-4dc7-9470-5b7f0078c27a%40googlegroups.com. For more options, visit https://groups.google.com/d/optout.
Exemple.gsheet
Description: Binary data
