I have a table generated by Power Query with multiple lines and rows in an .xlsm file that looks as follows: TABLE_EXAMPLE
When I export the file to CSV this is what I get:
Date;Description;Value
24.07.2021;VILVIDA;185,13
24.07.2021;EGLUOMEDA;599,94
24.07.2021;;785,07
Whereas the expected result would look like this(single line with delimiters in between values):
Date;Description;Value;24.07.2021;VILVIDA;185,13;24.07.2021;EGLUOMEDA;599,94;24.07.2021;;785,07
I have tried "TEXTJOIN", "CONCAT" and "CONCATENATE" to try to get desired output at least inside the excel file itself but most of the time it would turn dates into weird numbers. And I could only do a pair of 3 values at a time.
Is there some easy way to do it that I am missing?