How to consolidate a document that has blanks

Hi,

I have a grid I stored comments on questions from customer. some question may not have been answered so it results in the cell being blank.

I would like to get to another document where all the available answers are consolidated, with no blank cells.

Below a screenshot of an example document.

so ideally I would like to end up in a situation like the below

Any idea?

Find more posts tagged with

Accepted answers

All comments

DanS

An idea is to use Smartsheet SDK (Smartsheet Developers) . Psuedo code

From column -- Comment1 to Comment3

From row -- Pippo to Caccola

If the current cell -- cell(row, column) -- is blank, go to the next column to find a non-blank value, if any, until you find a non-blank value, or you arrive at the last column (Comment3)

then iterate to

Next row,

Next column

Stefano Ferretti

Hi @DanS ,

I've never used the SDK, but i'll take a look.

is this a free module? or does it require additional licensing?

DanS

It is free, but will require knowledge in writing scripts. For my projects, I use Smartsheet's Python SDK - smartsheet-platform/smartsheet-python-sdk: Library that uses Python to connect to Smartsheet services (using API 2.0). (github.com)

Sign in to join the conversation!

Quick Links

Component react.discussion.discussions had an error.

ref must be one of: categoryID, siteSectionID, category, category/categoryID, category/name, category/description, category/url, category/allowedDiscussionTypes, locale, siteSection, siteSection/basePath, siteSection/contentLocale, siteSection/sectionGroup, siteSection/sectionID, siteSection/name, siteSection/description, siteSection/apps, siteSection/attributes, layoutViewType, discussionID, commentID, page, sort, discussion, discussion/name, tags, breadcrumbs, discussionApiParams, serverDraftID, serverDraft.