let // Read NVDA's file (one GET, no key), naming your own project Stock = Json.Document(Web.Contents( "https://tickerinside.com/api/v1/sec/nvda.json", [Headers = [#"User-Agent" = "MyProject/1.0 (+https://example.com)"]])), // holders is sorted, largest weight first: [fund, weight %, file date] Holders = Table.FromRows(Stock[holders], {"fund", "weight_pct", "holdings_as_of"}), Typed = Table.TransformColumnTypes(Holders, {{"fund", type text}, {"weight_pct", type number}, {"holdings_as_of", type date}}, "en-US"), // The line to cite, on every row Cited = Table.AddColumn(Typed, "cite_as", each Stock[cite_as], type text) in Cited