One row and include the additional categories excel help

Asked By 20 points N/A Posted on -
qa-featured

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.

SHARE
Best Answer by Experttechyv
Best Answer
Best Answer
Answered By 0 points N/A #87620

One row and include the additional categories excel help

qa-featured

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

 

Answered By 0 points N/A #87621

One row and include the additional categories excel help

qa-featured

 

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.

Login/Register to Answer

Related Questions