Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Hi all need some help in excel transpose
I need a macro to transpose data in the excel.The data that i have is
in the following format: Summary Some data Steps 1)Some data 2)Some data Expected Result Some data Keywords Some data This is repeated in the next row and so on.. I need it in the following format Summary Steps Expected Result Keywords somedata 1)Some data Some data Some data 2)Some data Summary Steps Expected Result Keywords somedata 1)Some data Some data Some data 2)Some data Note that the number of steps under the steps column here vary from 1 to 10. Thanks in advance Ash |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Hi all need some help in excel transpose
See response in .excel
-- HTH Bob Phillips (remove nothere from email address if mailing direct) "ash" wrote in message ups.com... I need a macro to transpose data in the excel.The data that i have is in the following format: Summary Some data Steps 1)Some data 2)Some data Expected Result Some data Keywords Some data This is repeated in the next row and so on.. I need it in the following format Summary Steps Expected Result Keywords somedata 1)Some data Some data Some data 2)Some data Summary Steps Expected Result Keywords somedata 1)Some data Some data Some data 2)Some data Note that the number of steps under the steps column here vary from 1 to 10. Thanks in advance Ash |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Hi all need some help in excel transpose
Hi Bob
The data is in the following format Summary Summary1 Steps 1)Steps1 Expected Result Expected Result1 Keywords: Keywords1 Summary Summary2 Steps 1) Steps2 2) Steps2 3) Steps2 Expected Result Expected Result2 Keywords: Keywords2 I need it as : Summary Steps Expected Result Keywords: Summary1 1)Step1 Expexted1 Keywords1 Summary2 1)Step2 Expexted2 Keywords2 2)Step2 3)Step2 Summary3 1)Step3 Expexted3 Keywords3 Any help on this will be great. Thanks Ash |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Hi all need some help in excel transpose
Hi Bob
The data is in the following format Summary Summary1 Steps 1)Steps1 Expected Result Expected Result1 Keywords: Keywords1 Summary Summary2 Steps 1) Steps2 2) Steps2 3) Steps2 Expected Result Expected Result2 Keywords: Keywords2 I need it as : Summary Steps Expected Result Keywords: Summary1 1)Step1 Expexted1 Keywords1 Summary2 1)Step2 Expexted2 Keywords2 2)Step2 3)Step2 Summary3 1)Step3 Expexted3 Keywords3 Any help on this will be great. Thanks Ash |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
Hi all need some help in excel transpose
Sorry I need it as :
Summary Steps Expected Result Keywords: Summary1 1)Step1 Expexted1 Keywords1 Summary2 1)Step2 Expexted2 Keywords2 2)Step2 3)Step2 Summary3 1)Step3 Expexted3 Keywords3 Thanks, Ash |
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
Hi all need some help in excel transpose
See further response in .excel.
-- HTH Bob Phillips (remove nothere from email address if mailing direct) "ash" wrote in message oups.com... Sorry I need it as : Summary Steps Expected Result Keywords: Summary1 1)Step1 Expexted1 Keywords1 Summary2 1)Step2 Expexted2 Keywords2 2)Step2 3)Step2 Summary3 1)Step3 Expexted3 Keywords3 Thanks, Ash |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
unhide menu bar in excel - just disappeared | Setting up and Configuration of Excel | |||
Open Excel 2003 from Windows Explorer | Excel Discussion (Misc queries) | |||
convert pocket excel back to standard excel | Excel Discussion (Misc queries) | |||
VBA for Excel 2000 file is corrupt | Excel Discussion (Misc queries) | |||
Excel 2002 and 2000 co-install. Control Which Starts ? | Excel Discussion (Misc queries) |