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);
I unfortunately do not quite understand that solution.
It looks like this is an example on how to do it with SQL in a webapp?
I was looking for instructions on how to do this in Excel PowerQuery. Can this be done there too?
DanHuber Try this (see attached).
- It looks like this is an example on how to do it with SQL in a webapp?
Yes.
this in Excel PowerQuery. Can this be done there too?
This M code works
https://answers.microsoft.com/en-us/msoffice/forum/all/how-to-automatically-create-a-new-row-with-data/3e78505c-0779-4d20-9387-0323a7df2b80
