How JustAnswer Works:

  • Ask an Expert
    Experts are full of valuable knowledge and are ready to help with any question. Credentials confirmed by a Fortune 500 verification firm.
  • Get a Professional Answer
    Via email, text message, or notification as you wait on our site.
    Ask follow up questions if you need to.
  • 100% Satisfaction Guarantee
    Rate the answer you receive.

Ask NewITZone Your Own Question

NewITZone
NewITZone, Computer Enthusiast
Category: Microsoft Office
Satisfied Customers: 90
Experience:  I have been using Office Pro for 10 years and implemented applications for business use.
53509759
Type Your Microsoft Office Question Here...
NewITZone is online now
A new question is answered every 9 seconds

I have data in a column and want to convert it to a table in

Customer Question

I have data in a column and want to convert it to a table in Excel.Current FormatColumn ANancy Xxx
Regional President
ABC Title
CIty, St(###) ###-####
emailChristopher Yyy
Past President
Title Group
Barrington, IL (###) ###-####***@******.***Andrew Zzz
COO
Associates
Newport Beach, CA (###) ###-####***@******.***And need it in a tableName Title Company Address Phone Email
NancyXxx Regional President ABC Title City, St (###) ###-#### email
Submitted: 4 months ago.
Category: Microsoft Office
Expert:  Bruce Wilner replied 4 months ago.

You can copy columns from Word, click on the first row of Excel cells (click - shiftclick - shiftclick )--as many as there are columns--and press CTRL-V to paste into Excel.

Customer: replied 4 months ago.
That will not work. I have a single column in excel and need the data into a table.
Customer: replied 4 months ago.
The single column in Excel does not have labels. I am looking for an automated way of doing it. Transpose won't work

Related Microsoft Office Questions