Unable to get Paste: Transpose to Work with My Data

Hi,
I have be searching the internet for a solution to my issue and haven't been able to find anything, until if found this forum. I hope you can help please.

I do a lot of family research on the net. I have stored information that I find on Excel, but would like to copy and paste info and then transpose it across the sheet. I found a lady on YouTube who gives tutorials on different family history websites, especially Ancestry.

The lady explains how she copies and pastes into Special/Text and all of her info just falls into place with headings and the names, places etc. When I do it, all the data goes into one column. I have searched on how to transpose this column but cant find anything that works as easily as the lady on YouTube does, and mine never works and just becomes a jumbled mess.

I even went to the same document the lady went to on Ancestry and followed her step by step, but my Excel still wouldn't do what hers does. Is there something in the Settings that may be different?

I would love to be able to do this, as it would assist greatly with my research. I tried to add the YouTube link here, but can't as I am a new member.
Thank you for reading.
Kind regards,
pmmc_au

Welcome to the forum.

It will either be what you are doing (incorrectly) or the nature of your data.

There are instructions at the top of the page explaining how to attach your sample workbook.

A good sample workbook has just 10-20 rows of representative data that has been desensitised. It also has expected results mocked up, relevant cells highlighted and a few explanatory notes.

Administrative Note:

Your thread title does not really convey what your request is about. Tell us what you are trying to do, not how you think it should be done.

Please take a moment to amend your thread title. Make sure that the title properly explains your request. Your title should be explicit and not be generic (this includes function names used without an indication of what you are trying to achieve).

Please see Forum Rule #1 about proper thread titles and adjust accordingly. To edit the thread title, open the original post to edit and then click on Go Advanced (bottom right) to access the area where you can edit your title.

(Note: this change is not optional. As you are new here, I have done it for you this time.)