Forum Discussion
Split a row into several rows with almost same content. PowerQuery?
Difficult to explain by me as non native english speaker, but I'll give you an example I have a table looking like this: Article Description Price E1 E2 E3 P1 P2 P3 1234 FirstThin...
with sql,
//select * from Sheet1;
cli_unstack~Sheet1~E,P;
select colExclude[上层] from Sheet1_unstack where regexp('\w+',E);