cell by cell transpose

  • Thread starter Thread starter ash
  • Start date Start date
A

ash

The datai have 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 in advance
Ash
 
Don't keep re-posting, you have an answer in previous postings!

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Cell by cell transpose 1
Hi all need some help in excel transpose 5
Help needed in excel transpose 5
Hi all i need some help on excel transpose 1

Back
Top