Ask Your Question

Revision history [back]

click to hide/show revision 1
initial version

If second sheet it's only for text delimiters, I think this can be done when saving as csv, selecting edit filter settings.

An option is using OFFSET(), putting in Sheet2.A1 =OFFSET(Sheet1.$A$1;ROW()-1;COLUMN()-1), always reference the same cell in sheet1 as the formula is.