3,028 reputation
513
bio website Blogger-hints-and-tips.blogsp…
location Ireland
age
visits member for 4 years, 1 month
seen 3 hours ago

May
30
answered How can I prevent users from reverting to an old version of a Google Spreadsheet?
May
27
answered Is there a way to export the text of blog entries, in Blogger, to individual text-files?
May
27
reviewed Approve suggested edit on How to take out my Youtube history?
May
23
reviewed Reject suggested edit on Semi-transparent background for Google presentation text box
May
23
revised How to calculate average screen reso. based on number of visitors using a spreadsheet?
deleted 14 characters in body
May
23
comment Google sheets split multi-line cell into new rows (+ duplicate surrounding row entries)
Someone could write a script for this (I'm not that someone!) - but really the time spent testing it would probably be greater than the time spend doing it manually.
May
23
comment Google sheets split multi-line cell into new rows (+ duplicate surrounding row entries)
You don't need to do the manual step for the whole thousand businesses. You only need to do it for the maximum number of pepole associated with any one of those businesses: eg if one business has six people, then there will be six new helper columns created, so you have to to a manual copy-and-paste six times, one for each column.
May
23
answered How to calculate average screen reso. based on number of visitors using a spreadsheet?
May
22
answered Conditional counts based on dates
May
21
reviewed Approve suggested edit on How do I print a list in Trello for offline use?
May
21
answered Single drop down with data from separate columns
May
20
answered Google sheets split multi-line cell into new rows (+ duplicate surrounding row entries)
May
19
reviewed Approve suggested edit on How can I subscribe to a Google mailing list with a non-Google e-mail address?
May
19
answered Which formula sums all values from a column in a line that contains a specific word?
May
19
comment Add public transport details to Google Maps (Cracow)
I'm not sure that it's only companies: in some cases, it's municipal authorities who are responsible for transport in their area, no matter who provides it, who can provide the data.
May
15
reviewed Approve suggested edit on Add public transport details to Google Maps (Cracow)
May
15
answered Add public transport details to Google Maps (Cracow)
May
15
comment How to convert rows into columns in Google Spreadsheets?
It's there in new sheets, was not available in the previous version, so will only be in older ones if you have converted them.
May
13
reviewed Reject suggested edit on Facebook: allowing friends of friends (but not the whole world) to see my posts
May
13
reviewed Reject suggested edit on How do I retrieve a message I accidentally archived in Gmail?