Notifications
Clear all
Power Query
2
Posts
2
Users
0
Reactions
127
Views
Topic starter
Hi Mynda, I'm using the Table.Pivot function below and Lines.ToText aggregator but can't seem to figure out how to insert the ";" seperator to seperate any text lines that are combined under the Date columns.
= Table.Pivot(#"Reordered Columns1", List.Distinct(#"Reordered Columns1"[date]), "date", "Href", Lines.ToText)
Posted : 23/11/2021 8:33 am
Hi Linda,
The Lines.ToText function requires the lines as a list argument first, then the line separator e.g.
Lines.ToText(LineList, ";")
You can't just add it to the end of the List.Distinct function.
It would be better if you can please upload a sample Excel file illustrating your data and query you have so far, and a mock up of the desired result.
Mynda
Posted : 23/11/2021 8:35 pm
