How do I reformat an address when certain values contain no data

  • 23 February 2024
  • 1 reply

I have a number of address lines, for example:


Address Line 1: Output Value

Address Line 2: Output Value

Town: No Data

City: Output Value

Country: Output Value

So if the value does not have data it creates a gap in the google doc spreadsheet. I want to be able change this so that it returns the next line and deletes the gap. 


I know google docs has an option to remove unused values when mapping but I need to return the next line, please could someone help?

This post has been closed for comments. Please create a new post if you need help or have a question about this topic.

1 reply

Userlevel 7
Badge +14

Hi @Jack97 

For us to have full context, post screenshots with how you're steps are outlining configured along with screenshots with how you were trying to use that data in the GDoc.