Hello,
I need to reformat (transpose) a column of values by breaking it up into multiple rows. I'd like to do this with a single copy and paste. Below is a link to an example. For example, if I have a column of values in A1-A6, I need to transpose values A1 and A2 to C1 and D1. Then i need to transpose A3 and A4 to C2 and D2, then i need to transpose A5 and A6 to C3 and D3.
https://docs.google.com/spreadsheet/pub?hl=en_US&hl=en_US&key=0Alus9pZZR1XOdGRPVHY1c3JwTHFSd0FJRGVjYjhGVnc&output=html
If I can't do this by a single copy and paste, is there any other way by enabling some type of script that execute multiple copy and paste commands?
Many many thanks for any advice.
I need to reformat (transpose) a column of values by breaking it up into multiple rows. I'd like to do this with a single copy and paste. Below is a link to an example. For example, if I have a column of values in A1-A6, I need to transpose values A1 and A2 to C1 and D1. Then i need to transpose A3 and A4 to C2 and D2, then i need to transpose A5 and A6 to C3 and D3.
https://docs.google.com/spreadsheet/pub?hl=en_US&hl=en_US&key=0Alus9pZZR1XOdGRPVHY1c3JwTHFSd0FJRGVjYjhGVnc&output=html
If I can't do this by a single copy and paste, is there any other way by enabling some type of script that execute multiple copy and paste commands?
Many many thanks for any advice.
