D
Delilah
Hi, I have a spreadsheet with many rows of data and 2 columns of data.
Format is like this with the row names differing at times between contacts:
Last Name Smith
First Name A.
Middle Name B.
Job Title Boss
Company ABC Company
Business Street 123 Main St
Business City Anywhere
Business State CA
Business Postal Code 90888
Business Phone (555) 123-4567
Business Fax (555) 123-4576
E-mail Address (e-mail address removed)
Notes no notes right now
Last Name Jones
First Name R.
Middle Name U.
Job Title Sr. Boss
Company XYZ Company
Business Street 987 East St
Business City Wheresthat
Business State CA
Business Postal Code 98009
Business Phone (555) 123-0987
Business Fax (555) 765-1234
E-mail Address (e-mail address removed)
I've tried using transpose but when I select the rows of data, Excel put all
of the data in the first two rows (what appears on the left of above example
are all headings in the first row, what appears on the right of the above
example all appear on the same row but they are different contacts that
should be on separate rows), it does give column headings but I want row A1
across to be the column headings from the rows, and rows B2 on down to be the
data.
Thanks for any help.
Format is like this with the row names differing at times between contacts:
Last Name Smith
First Name A.
Middle Name B.
Job Title Boss
Company ABC Company
Business Street 123 Main St
Business City Anywhere
Business State CA
Business Postal Code 90888
Business Phone (555) 123-4567
Business Fax (555) 123-4576
E-mail Address (e-mail address removed)
Notes no notes right now
Last Name Jones
First Name R.
Middle Name U.
Job Title Sr. Boss
Company XYZ Company
Business Street 987 East St
Business City Wheresthat
Business State CA
Business Postal Code 98009
Business Phone (555) 123-0987
Business Fax (555) 765-1234
E-mail Address (e-mail address removed)
I've tried using transpose but when I select the rows of data, Excel put all
of the data in the first two rows (what appears on the left of above example
are all headings in the first row, what appears on the right of the above
example all appear on the same row but they are different contacts that
should be on separate rows), it does give column headings but I want row A1
across to be the column headings from the rows, and rows B2 on down to be the
data.
Thanks for any help.