Joining rows in a new column - Power Query

leandro22brito

New member
Joined
Nov 10, 2021
Messages
9
Reaction score
0
Points
0
Excel Version(s)
2010
Hello guys.


Please, i need help joining lines in a new column in power Query.

I looked for this information on some sites and videos, but I couldn't get it.

2021-11-10 15_41_56-BASE_TESTE - Power Query Editor.png



The dates must be on the same line as the employee name, separated by a comma. This is how i want this data:

2021-11-10 15_48_26-BASE_TESTE - Power Query Editor.png

Can you help me with this?

Thank you all.
 
I'm curious if you still needed the lines under (what I assume is) the name. In the attached, I've distilled it down to just Nome and the concatenated data. But do you actually really need the sub-records shown as in the second image?
 

Attachments

  • leandro.xlsx
    17.9 KB · Views: 16
Hi ken,

Thats it, exactly what i wanted. I dont need the sub records.

I'll try these steps you made, and inform you if it works.

Thank You.
 
Back
Top