Rows to Columns

[Shazam]

I have a spreadsheet that in A2 =NAME, B2 = ADDRESS, C2 = DENTAL, C3 =
MEDICAL, C4 = HCRA. I need to place column C to a horizontal range where C3
will be D2 and C4 will be E2. I have over 1800 entries with about 400 names.
It is too large to use the paste special "transpose" function. Any
suggestions.

Thank you.

 

[Teethless mama]

Select your range > right click Copy > right click Paste Special > Transpose

 

[Shazam]

I could not get this work. No matter what I did I could not get the copy
area and the paste area the same - even though it was correct. I tried
smaller range boxes and tried the transpose function but it stacked the name,
address, dental on top of each other and then placed the HCRA and Medical in
separate colums.

 

[Max]

Presuming your data in C2 down is like this, in groups of 3:

dental1
med1
hcra1
dental2
med2
hcra2
etc

Put in D2: =OFFSET($C$2,ROWS($1:1)*3-3+COLUMNS($A:A)-1,)
Copy across To F2, fill down as far as required to exhaust the data in col
C. Then freeze cols D to F, delete col C.
--
Max
Singapore
http://savefile.com/projects/236895
Downloads:17,500 Files:358 Subscribers:55
xdemechanik