how to analyze data?
Hi challa!
thanks for reply...but your reply doesnt solve my problem..an error occur
when i try to use transpose function.The information cannot be pasted because
the copy area and the paste area are not the same size and shape.
you help is very appreciated.
--
Regards,
Linda
"challa prabhu" wrote:
Hi,
Small correction- forgot to use the "Transpose" command in my earlier post.
- Corrected the procedure again-
You have to select the list; copy it to the clipbaord and then use the
"Paste Special commad from the Edit menu, and then select the Transpose
check box and click OK, in a different cell location in the
worksheet.
Note: You might have to repeat this process more than one to achive what you
require.
Challa Prabhu
"linda" wrote:
hi!
i've got a table in excel worksheet which part of it looks like this:
columnA|column B|
cust1 | mod1
cust2 | mod2
cust1 | mod1
cust1 | mod2
cust2 | mod3
cust2 | mod3
but,i need to recreate the table in a new worksheet to be analyze,to create
chart from the data..this is what i expect:
cust | mod1 | mod2 | mod3 |
cust1| 2 | 1 |
cust2| 0 | 1 | 2
i've try to use filter,but still can't do this..i dont want to create it
using pivot table cause i want it to be static..i hope to do this in macro
cause i want to assign it to a button but i'm not really familiar with
macro..so,i dont have any idea to solve my this.is there any solution for
this?if yes,how?
thanks in advanced.
--
Regards,
Linda
|