Jump to content

Spreadsheet vs Database

Recommended Posts

@Pat Stanford I don't think I can do it in excel either, though I'm not an excel whizz and I maybe could with some research!

A quick google tells me I need to learn PIVOT tables, which look awful 😂


I have 200+ entries / rows, where one of the columns is text responses to a consultation.

Many of the text responses are the same, so I'd like to summarise the duplicates, so that on the drawing I just get each response once. 


I've done this before with the database function lots and it's really helpful.

Link to comment

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.

Reply to this topic...

×   Pasted as rich text.   Restore formatting

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

  • Create New...