M
Michelle
Hi,
I know if I have few columns I can transpose it to rows by using the
function "Transpose". But if I have hundreds of columns that content the
same information, how can I transfer them to Rows. Please see the sample
below.
Name MICRO ABRASIVES CORP.
City WESTFIELD
Address 720 SOUTHAMPTON RD., PO BOX 669
Zip Code 01086-0669
Region MA
Tel (413) 562-3641-
Fax (413) 562-7409-
Name FINISHING SOLUTIONS INC.
City WESTFIELD
Address 103 SERVISTAR INDUSTRIAL WAY
Zip Code 1085
Region MA
Tel (413) 568-3765-
Fax (413) 572-4088-
Name O S WALKER COMPANY
City WORCESTER
Address 20 ROCKDALE STREET
Zip Code 01606-1995
Region MA
Tel (508) 853-3232-
Fax (508) 852-8649-
Thanks,
Michelle
I know if I have few columns I can transpose it to rows by using the
function "Transpose". But if I have hundreds of columns that content the
same information, how can I transfer them to Rows. Please see the sample
below.
Name MICRO ABRASIVES CORP.
City WESTFIELD
Address 720 SOUTHAMPTON RD., PO BOX 669
Zip Code 01086-0669
Region MA
Tel (413) 562-3641-
Fax (413) 562-7409-
Name FINISHING SOLUTIONS INC.
City WESTFIELD
Address 103 SERVISTAR INDUSTRIAL WAY
Zip Code 1085
Region MA
Tel (413) 568-3765-
Fax (413) 572-4088-
Name O S WALKER COMPANY
City WORCESTER
Address 20 ROCKDALE STREET
Zip Code 01606-1995
Region MA
Tel (508) 853-3232-
Fax (508) 852-8649-
Thanks,
Michelle