Posted to microsoft.public.excel.worksheet.functions

DHM

external usenet poster

Posts: 13

convert columns to rows

I have a groups of 6 cells that are in column A (A1, A2, A3, A4, A5,A6). I
want to change the 6 cells in column A to create new columns B1,C1,D1,E1,F1 &
G1. Then the second set of 6 cells in A (A7,A8,A9,A10,A11,A12) become
B2,C2,D2,E2,F2 & G2) and so on. I am using Excell 2007. Let me know if this
can be done

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Convert rows to columns	lucrezia	Excel Worksheet Functions	0	June 28th 07 06:36 PM
Convert columns to rows	KT	Excel Worksheet Functions	1	October 8th 06 02:10 PM
to convert columns to rows having mulit independent group columns	Quacy	Excel Worksheet Functions	1	August 22nd 06 11:20 PM
Convert rows to Columns	Ed	Excel Worksheet Functions	7	August 3rd 06 10:14 PM
Can I convert columns to rows?	Adam@Penda	Excel Discussion (Misc queries)	3	January 11th 05 07:35 PM

All times are GMT +1. The time now is 06:59 PM.

About Us

"It's about Microsoft Excel"

Menu

About Us