ExcelBanter - cell by cell transpose

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - cell by cell transpose (https://www.excelbanter.com/excel-discussion-misc-queries/86303-cell-cell-transpose.html)

cell by cell transpose

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

cell by cell transpose

Don't keep re-posting, you have an answer in previous postings!

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

"ash" wrote in message
oups.com...

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