Tools for pulling certain data

[kmc]

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.

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

 

[Kerryx]

Extract data (if permissions are ok) using Power query in excel, you can easily transform the data in excel using this