Please help convert row labels to column headers!

  • Thread starter Thread starter P Martin
  • Start date Start date
P

P Martin

I am exhausted trying to find out how to convert a
database of 1000+ contacts that are in a repeated row
format as follows:
Name
Title
Company
Address 1
Address 2
Address 3
Address 4
Type
Phone #
Mobile #
Fax #
Name
Title
Company
Address 1
Address 2
Address 3
Address 4
Type
Phone #
Mobile #
Fax #

I need to consolidate this contact information from row
labels (row headers) into column headers. How do I do
this? Please help. Excel help is useless and I cannot
find any answers even close to what I am trying to do
which should not be a difficult request.

Thanks to anyone who can help!

Kindest Regards,

Pam Martin
 
Pam

Assuming that your data starts in cell A1 and continues
down, then the name will be in cells A1, A12, A23...

In cell D1 enter the formula
=INDIRECT("A"&ROW()*11-(14-COLUMN()))
and copy across to N1
Copy down to cover your data.

Tony
 
Back
Top