Last seen: Jun 13, 2025
How about uploading a sample data worksheet and then showing a mocked up solution. We only need 8-15 records.
crossposted:
Since you are using O365 Create your list of stock symbols. Highlight and click on stocks In an adjacent column, click on the little box that...
Look at this link--> on the use of cell("address" functionality
James, I downloaded your file and refreshed both connections without issue. I am running Win11 and Office 365 Insider. Sorry, I cannot offer any ...
@Riny Very slick. I like how you did this!!
crossposted at:
Check out this link
Easier to provide a solution if you upload the worksheet instead of picture which cannot be manipulated. I think without actually applying to data th...
See the attached whereby I split the first column in Power Query and then exported the query to the Data Model. This then allowed the creation of two...
crossposted at: and at:
Pictures are of little value as we can not ascertain the format or functionality of the cell values. Suggest you upload a sample file that is represe...
let Source = Excel.CurrentWorkbook(){[Name="Table1"]}[Content], #"Changed Type" = Table.TransformColumnTypes(Source,{{"DATA", type text}}), #"Added Cu...
It may be helpful if you attach the file here so that we can test the the query.