Forum Discussion
combine data
I wish to combine rows of data linking unique email addresses to all the row/seat numbers associated with that address. (Note: I separately combined the row and seat columns with a formula, but I am ...
- Thanks so much Oliver. Copying the data and pasting it in the blue table and refreshing the green table works great!
select * from Sheet1 limit 20;
select f01,f02,f03,f04,f05,f06,group_concat(f07) from Sheet1 group by f01;
Hi peiyezhu. Thanks for yur solution. Someone else sent a solution that works, but your solution may be easier to do. Could you please send me instrutions for each step of the process using your formula? Also, what does the "limit 20" do. I have tables that can have up to about 130 rows.
