Forum Discussion
Transposing data related to same ID in row
Hello, I have a table where column A is for ID, column B is the date for measurements in column C. I would like to transpose rows having the same ID to columns where column A would be the ID,...
https://z1.ax1x.com/2023/09/28/pPb1QJg.jpg
select id,group_concat(nscore_date||'</td><td>'||nscore,'</td><td>') detail from stack_related_to_id group by ID;
OliverScheurichpeiyezhuPatrick2788, thank you for your input, it worked!
I want to now copy/paste my new table in a new worksheet but Excel is displaying an error message since this second table is dependent on the first one.
How do I "break" this dependence to make it possible to create a new worksheet with this new data presentation without the first table?
