I often copy a page of info from a website then paste to notepad, then Excel. I find the data is usually listed vertically in COL A without a way to easily transpose or manage and sorting removes the initial associations.
Example below.
So, in this case, I wish to keep the association of alphastring 1 to alphastring 3 only.
What tool do I use?
Thank you
Example below.
Book1 | |||
---|---|---|---|
A | |||
1 | alphastring 1 | ||
2 | alphastring 2 | ||
3 | alphastring 3 | ||
4 | alphastring 4 | ||
5 | alphastring 5 | ||
6 | alphastring 6 | ||
Sheet2 |
So, in this case, I wish to keep the association of alphastring 1 to alphastring 3 only.
What tool do I use?
Thank you