Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
I have data that goes
Name,Project,Period,Count A1, B1, 5,10 A1, B1, 6,20 A1,B2,5,5 A,B1,5,20 A2,B2,5,10 A2,B2,6,100 A3 A4,B3,5,200 And I want it to look like (filtering out the A3) Name Project Period5 Period6 A1 , B1, 10, 20 A1, B2, 5 A2, B1, 20 A2, B2, 10, 100 A4, B3, 5, 200 Or to do this do I have to write the VBA and work on all the looping? Thanks. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Parameter Input for Goal Seek | Excel Discussion (Misc queries) | |||
Transposition impossibility? | Excel Discussion (Misc queries) | |||
Can I user input to seek out particular files and copy/move them? | Excel Programming | |||
Transposition | Excel Worksheet Functions | |||
Transposition of data | Excel Programming |