create table with "Tab" separated data in column

[bbo22]

Hi all - head is twisted in a knot... I have the following:

Name

Product 1​

Product 2​

product ​

Name 2

Product (p)​

Product (k)​

Name 3

​

​

To the right of each product I have amount. I want to do basic analysis by sales per product per client. I don't know how to get this data in a table. I could pivot table but I don't know how to identify the client transactions (names + products bought)

Any help?

 

[Smitty]

Welcome to the Board!

Are the purchased products under each customer name? Could you post a better example of your layout (see the HTML Maker link in my sig for posting a screen shot).

 

[bbo22]

Here is an example several categories. Its a mess. Exported from another software: (hope the html is correct) and thanks!

Excel 2012
	A	B	C	D
1	Cod	Details	Quant	Price
2	20001	John Smith
3		Services
4		Maintenance
5	12	Maintenance colour	4	160.00
6		Gloss
7	17	Colour gloss	2	50.00
8	19	EXPRESS Gloss	2	50.00
9		Specials
10	37	Month special	1	35.00
11
12	20002	Peter Hill
13		Services
14		Gloss
15	17	Colour gloss	1	25.00
16	19	EXPRESS Gloss	5	125.00
17
18	20003	Mary Ann
19		Services
20		Maintenance
21	12	Maintenance colour	7	280.00
22		Gloss
23	17	Colour gloss	2	50.00
24	19	EXPRESS Gloss	8	200.00
25
26	40267	Paul Sapu
27		Services
28		Maintenace
29	10	Maintenace format	2	70.00
30	12	Maintenance colour	2	80.00
31		Gloss
32	17	Colour Gloss	1	25.00
33		Items
34		Products
35	15.0001	Express paint	1	12.50
Sheet1

 

[bbo22]

Under John Smith Services and maintenance should be indented like Peter Hill

 

[Smitty]

What's up with row 35?

 

[bbo22]

35 is weird product code. Services have a simple number products have an idiotic code... Maddening!