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 |
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 |
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 |
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 |
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 |
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 |
All times are GMT +1. The time now is 02:22 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com