This should become a part of the NSSA training. There is a written tutorial here in Discussions, where I explained piranna’s method to someone else.
She briefly demonstrates it at the end of this video which is about something else.
I tweaked it a little because for me “paste special”+“values only” sometimes didn’t work, so I pass them through Notepad to clean them up before copying to the Google sheet. But for some it’s not necessary.
Dudie had to make some other tweak to make it work for Mac.
We can circulate it to all segmenters.
2 Likes