Power Query--pass parameter to web query and separate result into three columns

Hello,

I have a power query in the attached sample, in which I need help to achieve the following

I am using excel 2016

1. the Parameter is in Column B which should be passed to web query to give result in column C
2. The Column C is returnig Date Month, Value and (Percent), I need these three data in seperate columns in D, E and F
so D=30 May
E=179.04
F=(-0.92%)

Administrative Note:

Welcome to the forum.

The thread title "Power Query" does not really convey what your request is about. Tell us what you are trying to do, not how you think it should be done.

Please take a moment to consider amending your thread title. Make sure that the title properly explains your request. Your title should be explicit and not be generic (this includes function names used without an indication of what you are trying to achieve).

Please see Forum Guideline #1 about proper thread titles and adjust accordingly. To edit the thread title, open the original post to edit and then click on Go Advanced (bottom right) to access the area where you can edit your title.

I have updated your title for you to describe your question.

1. Why change the type of values in all the columns if you then remove all but the first column. Only change the type for column 1.
2. Instead add this to your Mcode

Please Login or Register  to view this content.

No errors in my file for your data as presented in your file.