FROM PREVIOUS POST:
Put this macro code in the module and assign a short cut key like ctrl a. First copy the data then press ctrlA . The data will transpose.
sub pastetranspose()
Selection.PasteSpecial Paste:=xlPasteAll, Operation:=xlNone, SkipBlanks:= _
False, Transpose:=True
end sub
Posted: 08/22/2005 @ 07:33 PM (PDT)
Is there a way to use this in the following way?
name address and city for 100 records in one vertical column. I want to copy and paste/transpose the 3 row records to appear in one row for each record, 3 columns across. each name and address starts oin a new row.
