Please help convert row labels to column headers!

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
 
A

acw

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top