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;
And the actual table in web looks like below;
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.
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;
And the actual table in web looks like below;
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.