ferocious12
Member
Hi All,
I have to transpose data from rows to columns. I have used offset formula to transpose data in column C to rows starting in column E (please see highlighted in blue). Can you help me with two issues:
1. How to change the formula so I drag it to E2-G2 (highlighted yellow) to get the data in column D7-D9
2. I have this fixed format to transpose the data. I want E3-G3 to pick up data from C24-C26 (highlighted in green). There is 14 rows in between (fixed number of rows between two sets of data)
I have to transpose data from rows to columns. I have used offset formula to transpose data in column C to rows starting in column E (please see highlighted in blue). Can you help me with two issues:
1. How to change the formula so I drag it to E2-G2 (highlighted yellow) to get the data in column D7-D9
2. I have this fixed format to transpose the data. I want E3-G3 to pick up data from C24-C26 (highlighted in green). There is 14 rows in between (fixed number of rows between two sets of data)