Add Data to a new column from a CEL to create a dataset.

[Murds]

Hello all,

I'm completely stumped with something on excel. I'd like to think of myself as a decently proficient user but I just cant get to the bottom of this. I've started a new job in a call centre and we have data that is annoyingly formatted. We have multiple customers and it is formatted a bit like this:

Customer 1	Calls inbound
range 1	1
range 2	2
range 3	5
Customer 2
range 1	1
range 2	5
range 2	6

<tbody>
</tbody>

What I really want is to add the customer name to a new column so I can pivot the data. So is there a formula that will allow me to fill in a new column based on the customer name (there's over 80 customers).

Essentially so the data will look like this:

Customer 1	Customer 1	inbound calls
Customer 1	Range 1	22
Customer 1	Range 2	25
Customer 1	Range 3	26
Customer 2	Customer 2
Customer 2	Range 1	22
Customer 2	Range 2	25
Customer 2	Range 3	26

<tbody>
</tbody>

Any help is greatly appreciated.

 

[Fluff]

How about

Excel 2013/2016
	A	B	C
1	Customer 1	Customer 1	Calls inbound
2	Customer 1	range 1	1
3	Customer 1	range 2	2
4	Customer 1	range 3	5
5	Customer 2	Customer 2
6	Customer 2	range 1	1
7	Customer 2	range 2	5
8	Customer 2	range 2	6
Run Macros

Cell Formulas
Range	Formula
A1	=B1
A2	=IF(LEFT(B2,8)="Customer",B2,A1)

 

[Murds]

How about

Excel 2013/2016

	A	B	C
1	Customer 1	Customer 1	Calls inbound
2	Customer 1	range 1	1
3	Customer 1	range 2	2
4	Customer 1	range 3	5
5	Customer 2	Customer 2
6	Customer 2	range 1	1
7	Customer 2	range 2	5
8	Customer 2	range 2	6

<colgroup><col style="width: 25pxpx"><col><col><col></colgroup><thead>
</thead><tbody>
</tbody>

Run Macros​

Worksheet Formulas Cell Formula A1 =B1 A2 =IF(LEFT(B2,8)="Customer",B2,A1) <thead> </thead><tbody> </tbody>

<tbody>
</tbody>

This worked an absolute treat!

 

[Fluff]

You're welcome & thanks for the feedback