Harry0
Member
Despite I think excel is like a skyscraper built on a 1 family home foundation in how backwards and limited the code is which should be done from the ground up again. Its bad when harder things are easier than things that should be easy.
Here is a fast way to transpose/concentrate vertical to horizontal in a cell.
Copy your column, then past it on your web URL, then copy you URL, then past in cell.
It is to get rid of the hidden special characters in the copy command. So a simple Just a simple copy, past,copy, past.
If you want spacing use ms word replace function, and replace space with tab in the special option.
Good luck
If this post gets erased like my other helpful tips which is stated nowhere else then it's your loss.
Here is a fast way to transpose/concentrate vertical to horizontal in a cell.
Copy your column, then past it on your web URL, then copy you URL, then past in cell.
It is to get rid of the hidden special characters in the copy command. So a simple Just a simple copy, past,copy, past.
If you want spacing use ms word replace function, and replace space with tab in the special option.
Good luck
If this post gets erased like my other helpful tips which is stated nowhere else then it's your loss.