transpose function

[kin]

Hi I have a series of data baut need to change how it appears in order to make my life easy for analysis.

In column A I have the name of the company, In B the products and in C the sales value
However A gives the name of one company while I d like A column to show the product descriptions. E.g. rows A6:A32 shows just tthe name of one company and rows B2:B32 the products for that company and then C2:c32 the sales for each product for that company.
As you understand the same happens for many other companies underneath and you know that this brings duplicates of products E.g product B appears 10 times because 10 customers purchased it.
I know want to change that so products appear in rows of A only one time each and companies in just one row like B5,C5 etc so there will be one sales value for one product for every company thta had this sale
Please help

 

[hiker95]

kin,

I will need to see a workbook containing the actual worksheet where your raw data is located (sensitive data scrubbed/changed/removed).

You can upload your workbook to www.box.net and provide us with a link to your workbook.

 

[kin]

I made a mistake I see something like this

Excel Workbook
	A	B	C	D	E	F
1	PRODUCT NAME	FRESH 2011	SWAN 2011	2011	PROTASIS A.E 2011	2011
2	VARIO EXTRA KOYZIN 10 X 630 . 1 . - (5-31-088)	0	0	0	0	#VALUE!
3	WC ECO 500. .12 65 - (5-30-077)	0	0	0	0	#VALUE!
4	ECONOMY LATEX MEDIUM 10X100 TEM 1 KIB. - (4-52-179)	0	0	0	0	#VALUE!
5	-115 4L XP. ULTRA FRESH 4 TEM. - (5-40-528)	0	0	0	0	#VALUE!
6	F-320 4L . 4TEM. - (5-40-065)	0	0	0	0	#VALUE!
7	. 5055. 10 Kg. 1 38 . - (4-66-023)	0	0	0	0	#VALUE!
8	MR-566 4L 4 TEM. - (5-40-032)	0	4,76	0	0	#VALUE!
9	WC ECO KOPE 48 YK. 12500. - (5-30-067)	0	0	0	0	#VALUE!
10	C-500 4L . ET 4 EM. - (5-40-017)	0	0	0	0	#VALUE!
11	ANT/KO OY. 300P.OIK.(BACTERIAL) .AO 10TEM. - (5-60-316)	0	0	0	0	#VALUE!
12	ECONOMY LATEX LARGE 10X100 TEM 1 KIB - (4-52-183)	0	0	0	0	#VALUE!
13	COMBITEX 3214 .13 - (4-59-006)	0	0	0	0	#VALUE!
14	. PROF. 1,30cm . 110 . - (5-58-042)	0	0	0	0	#VALUE!
15	ECONOMY . 18. 1 - (4-52-320)	0	0	0	0	#VALUE!
16	ANT/KO OY. 400P.EYKO HIL 2/6 25 TEM. - (5-60-307)	0	0	0	0	#VALUE!
17	FOOD PAPER EXTRA 2 1000 X 4 ( 4-39-040) - (5-31-092)	0	0	0	0	#VALUE!
18	. 75105. 10 Kg. 1 12 . - (4-66-042)	0	0	0	0	#VALUE!
19	FP-330 4L . EYKO 4 TEM. - (5-40-063)	0	7,24	0	0	#VALUE!
20	U-520 4L . 4 TEM. - (5-40-002)	0	0	0	0	#VALUE!
21	/ 2525 2 48100 - (4-32-401)	0	0	0	0	#VALUE!
22	/ . - . 200 23 . 1 KIB. - (5-33-045)	0	0	0	0	#VALUE!
23	XEIPO 1 EXTRA PLUS 23 - 7000 - 15467 . - (5-31-005)	0	0	0	0	#VALUE!
24	AKOYA . MAYPH 105X120EK. 10 Kg. 1 8-9 . - (4-66-020)	0	0	0	0	#VALUE!
25	WC EXTRA 200 P. KOPE YK. 30 POA - (5-30-013)	0	0	0	0	#VALUE!
26	. 75105. 5kg. 1 12-13 . - (4-66-142)	0	0	0	0	#VALUE!
27	AKOYA . MAYPH 75X105EK. 10 Kg. 1 12-13 . - (4-66-021)	0	0	0	0	#VALUE!
28	BAC-100 () 10L - (5-40-633)	0	26,51	0	0	#VALUE!
29	210ML . 40 50 . - (4-66-102)	0	0	0	0	#VALUE!
30	FP-400 44L TEM. - (5-40-641)	0	0	0	0	#VALUE!
31	TUTO FARE 3040 1100. - (4-59-012)	0	0	0	0	#VALUE!
32	ATIKH PEA . 4 TEM - (5-60-230)	0	0	0	0	#VALUE!
33	COMBIMAT TD 581 4L . KAAPITIKO 4 TEM. - (5-40-151)	0	37,09	0	0	#VALUE!
34	H-110 4L XPOAN 4 - (5-40-521)	0	0	0	0	#VALUE!
35	COMBITEX 3214 14 - (4-59-022)	0	0	0	0	#VALUE!
36	FP-400 1L12 TEM. - (5-40-640)	0	0	0	0	#VALUE!
37	VO-300 ECONOMY 4L 4 TEM. - (5-40-270)	0	4,29	0	0	#VALUE!
38	ANT/KO OY. 400P.EYKO YK. 30 TEM. - (5-60-306)	0	0	0	0	#VALUE!
39	LA-210 500ML . . 24 . - (5-40-134)	0	0	0	0	#VALUE!
Results

the good thing is that product descriptions are unique, but all customer names with greek fonts have zero euro sales there is also this column called 2011 with the error and also this ?.? which categorises a company e.g. S.A. The one name i had in english took the correct values !

 

[kin]

i know there must be a problem with the alphabet I m using

 

[hiker95]

kin,

Per your Private Message:

I uploaded it on box.net what do i do now?

On Box.Net you have to mark your workbook to be shared, and provide us with a link to the workbook.

 

[hiker95]

kin,

There is a section at the MrExcel Forum for Questions in Other Languages:
http://www.mrexcel.com/forum/forumdisplay.php?f=12

 

[kin]

http://www.box.net/signup/collablink/d_88906078/711345e1bf0aa

 

[hiker95]

kin,

You link is requesting an ID and Password.

You have to mark your workbook to be shared, then provide us with a link.

 

[kin]

http://www.box.net/shared/54sy96rsb2

Is this the link?

 

[hiker95]

kin,

Got it - thanks.

 

[kin]

i noticed one row is blank I wonder if i lost some piece of data