One row and include the additional categories excel help

Asked By Manding Libria 20 points N/A Posted on - 01/12/2012

I need help with my Excel file. I have a file containing a comma separated values (CSV) list. This list contains information of companies’ contact details and their categories. There are several categories. Right now for each category, there is a separate row containing the business/company information.

I want to have all the information in one row and include the additional categories. Does anyone know how to consolidate the information with a command or a macro or whatever process? It will take me several weeks to complete the consolidation manually. Thanks for helping.

• Status: Open
• Question Views: 972
• Answer Count: 2
• Vote Up 1 Vote Down

• Answer Accepted: Yes
• Question Category: MS Excel

Best Answer by Experttechyv

Go To Solution

Best Answer

Best Answer

Answered By Experttechyv 5 points N/A #87620

One row and include the additional categories excel help

I am so sure why you will need to do that because the arrangement of the data will not be good in one row. Since there are many categories of information that you are listing, it is better if you group them in various columns and rows to avoid having the data scattered all over as it will be the case when you consolidate the data in from all rows and columns into a single row. But if you need to still make the data be in one row, then the command you will use here is merge cells, whereby you will highlight those that you will want to consolidate and then right click on them and then choose merger cells.

-Experttechyv

 

About Experttechyv

Questions
0

Answers
200

Best Answers
30

• Vote Up 0 Vote Down

• Posted on - 01/20/2012
• Question Category: MS Excel

Answered By Anthew Staw 0 points N/A #87621

One row and include the additional categories excel help

 

What you’re saying is that for column A you have “info of company, contact details, categories” and in column B “additional categories” and you have headings in the first row, right? In this case what you need to do is to key-in ‘=A2&”, “&B2’ in cell C2. Then drag down C2 until where you want to consolidate. I hope this helps.

About Anthew Staw

Questions
3

Answers
34

Best Answers
3

• Vote Up 0 Vote Down

• Posted on - 08/02/2012
• Question Category: MS Excel