Help on TRANSPOSE

[Hrishikesh Sandilya]

Please refer to the attached spreadsheet.

The box on the left is the raw data and the box in the right is how I want them.

I have tried TRANSPOSE, but didn't get the desired result.

Any better way to do this?

 

[Look]

Part of the problem is that your raw data is not consistent; different numbers of rows per entry etc. If it was exactly the same format in each entry, transpose or a macro could do it quite easily. I don't see any way to automate it unless there is a discernible pattern in your data- I don't see one.

 

[Faseeh]

One suggestion could be to merge the address lines, then the start up line, Accrediated in, Website and Expiration Date can be identified.