Calc: multiple lines per row for print-friendly sheet

[kngharv]

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

[Grantler]

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

[kngharv]

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.