Formatting a data which is pasted from Web page through Delimiter or any other m

[ajayxlnc]

Hello,


I have pasted data from a table in the Webpage to the Excel and i found the result (Screen Shot attached)


https://docs.google.com/file/d/0B_8nXiEldUKKRnpQMHJXSVlZSEE/edit?usp=sharing


In the file, from A1:C10 is the sample data which i have pasted from a Web Page Table.

But when i pasted it is not in a proper way i tried to use delimiter but of no use.


Can you help me out in finding a generic solution where in i can format the pasted data like E1:J3 in the sample data, i have to do the activity daily. This would be helpful in pasting the data and also using it for other needs.


Need you help so find a solution

 

[SirJB7]

Hi, ajayxlnc!


Just in case your uploaded file has an error and pasted data were like this:

-----

[pre]

1
1301		0,71
31.01.2013	 13.02.2013	10
2
0,72
14.02.2013	 27.02.2013	10
3
0,73
28.02.2013	 13.03.2013	10

[/pre]
-----

you could try these formulas:


E1: =INDICE(A:A;(FILA()-1)*3+1) -----> in english: =INDEX(A:A,(ROW()-1)*3+1)

F1: =A2

G1: =INDICE(B:B;(FILA()-1)*3+2) -----> in english: =INDEX(B:B;(ROW()-1)*3+2)

H1: =INDICE(A:A;(FILA()-1)*3+3) -----> in english: =INDEX(A:A;(ROW()-1)*3+3)

I1: =INDICE(B:B;(FILA()-1)*3+3) -----> in english: =INDEX(B:B;(ROW()-1)*3+3)

J1: =INDICE(C:C;(FILA()-1)*3+3) -----> in english: =INDEX(C:C;(ROW()-1)*3+3)

Copy down E,G:H as required.


If that doesn't work would you mind posting the source URL?


Regards!