Forum Discussion
spalmer
Sep 17, 2025Iron Contributor
Excel Formula Help
Hi everyone, i am needing help pulling data from one sheet to another. The "DATA" tab is a bunch of data that is pulled from a Microsoft forms survey and i copy and paste it in the sheet. Once i copy...
peiyezhu
Sep 18, 2025Bronze Contributor
One to many report:
create temp table aa as
select udf_concat(f03,f04,f05,f06,f07,f08) module,* from Data limit 20;
select * from aa;
select f01,f02,group_concat(module||f09||f10||f11||f12||f13) 子表 from aa group by f01,f02;
spalmer
Sep 18, 2025Iron Contributor
Thank you for your Help!