Transposing Row Data To Columnar Data, In Sets of Four

**edgeblade** · 10-11-2010, 05:11 PM

Hello All,

I am working with some data where I need to take the values of a varying number of rows and copy the values into corresponding columns, in sets of 4. So it would go like this: C2 is copied to D2, C3 is copied to E2, C4 is copied to F2, C5 is copied to G2, and so on. XLSX workbook is attached. I have no idea is this is possible through built in functions or if would be better to use VBA. Any help would be appreciated. Thanks.

**cmyers** · 10-11-2010, 05:43 PM

Copy your range, then click on D2 and go to Paste Special and select "Transpose".

Hope this helps!

**edgeblade** · 10-12-2010, 12:06 PM

Originally Posted by cmyers

Copy your range, then click on D2 and go to Paste Special and select "Transpose".

Hope this helps!

That works sorta, but not quite. I can't do that because I have values in the columns beyond column G. So I can only transpose 4 values at a time. I'm guessing a macro would probably be needed to do this.