Most valuable professional
  • Hot Topics

Excel Concatenate with obstacles

Hi, I have the following excerpt from a system (Table 1). However I need to change this input and make it look like the Table 2. The data is not very homogenous, which makes it very troublesome to use the CONCATENATE or any other Function. Sometimes the system can only find old data (see company B) so then I have to work with this. Sometimes it puts Geographic Segments and says they are 0(-) as you can see with company A below, which should not be in the output. It usually is more than 3 companies and each of them can have various numbers of segments they operate in. The output for each company should look like the following: Segment 1 (Percentage), Segment 2 (Percentage),... Can anyone help me to write a macro that solves this problem? Let me know if something is not clear and thank you in advance! Table 1 (INPUT) 1 2 3 4 5 6 7 1 2 3 1

This question generated 13 answers. To proceed to the answers, click here.

This thread is current as of March 8, 2017.

For more resources for Microsoft Excel:

This article includes the following tags:

  • Excel
  • Microsoft Excel