C
Carl
Each week I get a huge amount of data sent to me in the format below
12500 12500 12500 13100 13100 13100
User Number
JAN FEB MAR JAN FEB MAR
Month Name
Beans 5 8 1 6 3
2
Bread 11 7 2 4 2
0
Jam 7 3 0 4 1
0
Total 22 18 3 14 6
2
So from this table I can see that USER 12500 sold 5 Beans in Jan, 8 in Feb
etc
I want to present the data with the user on the left, the products along
side it, like :
Jan Jan Jan Feb Feb Feb
Beans Bread Jam Beans Bread Jam
12500 5 11 7 8 7 3
13100 6 4 4 etc
At first I though I could transpose the data when pasting but that isnt
working.
I am scratching my head as I dont know if I would be best using a lookup,
and index, IF's?
Any advice on the best way to tackle it?
Many thanks!
Carl.
12500 12500 12500 13100 13100 13100
User Number
JAN FEB MAR JAN FEB MAR
Month Name
Beans 5 8 1 6 3
2
Bread 11 7 2 4 2
0
Jam 7 3 0 4 1
0
Total 22 18 3 14 6
2
So from this table I can see that USER 12500 sold 5 Beans in Jan, 8 in Feb
etc
I want to present the data with the user on the left, the products along
side it, like :
Jan Jan Jan Feb Feb Feb
Beans Bread Jam Beans Bread Jam
12500 5 11 7 8 7 3
13100 6 4 4 etc
At first I though I could transpose the data when pasting but that isnt
working.
I am scratching my head as I dont know if I would be best using a lookup,
and index, IF's?
Any advice on the best way to tackle it?
Many thanks!
Carl.