• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Copy Table Data in Web and Paste to Excel As Rows & Columns

Junarkar

Member
Hi,

While copy pasting a table from web to excel, the data is not getting pasted as rows and columns. It is getting pasted like below;

77084

And the actual table in web looks like below;

77085


I tried below methods;

1. All paste special options in Excel - All of them gave same results.
2. First paste to Notepad/Word, then copy paste from there - It is getting pasted in notpad & word in the same order as shown in 1st Image. Tried all paste special options available in MS Word also. Ni luck.

Can someone help me to share some ways to get it pasted as Rows and columns.

Sample file is attached.
 

Attachments

  • Book10.xlsx
    18.6 KB · Views: 0
Back
Top