Cell by cell transpose
 

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

Cell by cell transpose
 

Please stop multi-posting;
You already have threads open on the same subject, with satifying responses.

Cheers,
--
AP

"ash" a écrit dans le message de news:
...

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