Forum Discussion
Combine two columns into one by inserting a row.
You very nicely replied to my impertinent question of "Why?!": I am looking to create a CSV file that can be upload to an accounting package and it is very specific about the layout or it rejects it. The files I download have all the information I need but in the wrong places (multiple columns) as I need certain information in one column, linked to a name and order number arranged in rows rather than columns.
First, thank you for explaining the purpose you were seeking to serve.
Second, your answer, I must say, surprises me. If only for this reason: when I get CSV files from various financial sources--Fidelity, Chase, Citibank, AmEx--they all are arrayed with records in rows, not columns. I.e., in what I'd call standard database fashion. So it is surprising to hear that this accounting package is asking for data records (or at least some parts of each record) arranged in columns.