Apache OpenOffice Community Forum

i'd like to merge data in writer which is separate lines to separate columns in calc. how do i do this without copying and pasting line by line?

If I understand well, you have a text in Writer like:
aaaa
bbbbb
ccc
ddd

And you want to paste it to Calc into columns, something like For that, first copy the text from Writer to Calc, so you have each line on one row. Then select in Calc the vertical range containing all the lines, press Ctrl-C (or Edit > Copy), then right click the destination cell, select Paste Special and click the box "Transpose".