This site uses different types of cookies, including analytics and functional cookies (its own and from other sites). To change your cookie settings or find out more, click here. If you continue browsing our website, you accept these cookies.
I have a joined data set which has rows with the same string value (Comments column). I have tried various ways of merging but cannot get to a result. Can anyone help please? Basically for the first three rows below, I would like the 3 rows in Comments column to be merged before I send a report out.
Right now it looks like that so you see the project ID merged on top left so it's not looking nice and somehow my comments column is not merging. I use several basic table to nest it but the header row is not right. I want it to be a merged head row
Can you put together a quick table of how you want it to look? it seems the two statements are conflicting - you want to roll-up the data, but you want the detail. To me, that looks like you want the original table.
what do you mean by merged comments? if you roll up the table by invoice, then you lose detail, but then the comments would be "merged" but that doesn't seem to be what you are looking for. can you please paste a table for the desired output?