Cell by cell transpose

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

ash

The data i 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
 
Please stop multi-posting;
You already have threads open on the same subject, with satifying responses.

Cheers,
 

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 i need some help on excel transpose 1
Help needed in excel transpose 5
Hi all need some help in excel transpose 5
How can I transpose reference cells by Auto-fill? 3
FWT Newsletter - Weekly - November 1, 2004 0

Back
Top