Calc: multiple lines per row for print-friendly sheet

asked 2019-04-02 08:23:16 +0200

kngharv gravatar image

Dear all:

I am working on Google Contact CSV, it contains headers like

Name, Family Name, Given Name, Birthday, Group Membership   E-mail 1 - Type,    E-mail 1 - Value,E-mail 2 - Type    ,E-mail 2 - Value,

Each row in Google Contact CSV contain ONE person's information

I want a way to automatically create a print-friendly, human-readable output on a separate sheet tab. (my first tab contains the CSV entry I called "input", my 2nd tab contain the print friendly output, which I called "print")
In order to do so, I need to create a sheet that contains multiple lines PER row

Name, Family Name, Given Name E-mail 1 Value E-mail 2 Value Address 1 Value Phone 1 Value

Then, replicate them through out the rows

How do I do that using functions? My problem is the following first entry is easy, everything is in the same row (let say, row 1), different values are in different column, no problem. But how do I reference the next row, row 2 in my "input" tab? mind you by the time I am done with my first entry, the I am already on row 6 in my "print" tab.

thanks in advance

edit retag flag offensive close merge delete


Labels are no option for you? Synchronizing? Mail Merge Wizard?

Grantler gravatar imageGrantler ( 2019-04-02 12:01:46 +0200 )edit

Labels would be my first choice. But it seems that Labels can only be created from a database. And I haven't find a way to customize my database which field is strictly based upon my sheet's column (instead of using existing "Address" database.

Further, ideally, I would like to contain everyone in a single workbook so people can easily see the output immediately instead of going through all these steps of exporting data in the sheet to a database.

kngharv gravatar imagekngharv ( 2019-04-02 21:38:07 +0200 )edit