How would a person go about formatting output from the rows of a spreadsheet in the form of:
A1 B1
C1
D1
E1
F1
A2 B2
C2
D2
E2
F2
for some undetermined number of rows.
The question seems to be incomplete. Can you explain what you start with and your desired result?
A sample file in .ods would help.
Thank you for looking at this. What I’m indicating is that the content of the original spreadsheet would be something like:
Cell A1 contains ‘participant 1 name’
Cell B1 contains ‘school 1 name’
Cell C1 contains ‘coach name’
Cell D1 contains ‘field event 1’
Cell E1 contains ‘field event 2’
Cell F1 contains ‘track event’
Subsequent rows contain information for subsequent participants. I want to be able to automatically generate output in the format of:
Participant 1 name School 1 name
Coach name
Field event 1
Field event 2
Track event
I was thinking of it being in another spreadsheet. I know I can create a reference for the first source row, but when I copy the target cells to the next five rows, it offsets five rows forward in the source spreadsheet. I’m hoping there’s some other method of which I’m unaware.