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.
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
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.
