Forum Discussion
Solved
Remov Reapeat and Transpse Data
Hello my friends I want in power query to remove the repeated rows and transpose the invoices like i showed in excel file , thank you fry your help
Jalal_1988 I trust you have a good reason for wanting to do this, since the data is already very well structured as it is. One would normally want to go from the 'transposed' data towards data in a tabular form. But that's your choice.
See attached.
sql:
//select * from basic_group_concat limit 20;
select row_number() over () NO,CODE,NAME,group_concat(INVOCIE,'</td><td>') INVOCIE from basic_group_concat group by CODE,NAME