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.