Forum Discussion
Help with excel formula
I am a self taught novice of excel and formulas and I am hoping that someone in this forum who is a formula guru can help guide me through a process. I will attach a sample document so that you can ...
Hi ,
sql:
select * from basic_group_concat limit 20;
cli_no_header;
select f01,f02,group_concat(f03||'</td><td>'||f04,'</td><td>') from basic_group_concat group by f01,f02
f01 f02 f03 f04
| Meg | Year 9 | JDRAa Drama Booklet compulsory - (THC) - payment due 04.03.24 | $10.00 |
| Meg | Year 9 | JMTHa Consumables (THC) - Term 1-2 - payment due 04.03.24 | $90.00 |
| Freddie | Year 9 | JFNTa Food & Nutrition Consumables (THC) | $85.00 |
| Freddie | Year 9 | JAGRa Agriculture Consumables (THC) - payment due 29.07.24 | $5.00 |
| Freddie | Year 9 | JMTHa Consumables (THC) - Term 1-2 - payment due 04.03.24 | $90.00 |
| Freddie | Year 9 | JFNTa Food & Nutrition Consumables (THC) | $85.00 | JAGRa Agriculture Consumables (THC) - payment due 29.07.24 | $5.00 | JMTHa Consumables (THC) - Term 1-2 - payment due 04.03.24 | $90.00 |
| Meg | Year 9 | JDRAa Drama Booklet compulsory - (THC) - payment due 04.03.24 | $10.00 | JMTHa Consumables (THC) - Term 1-2 - payment due 04.03.24 | $90.00 |
