One record spreads over multiple rows. The purpose is to make them one
row and save as text file (in order to import into another program).
Because of column number limitation, I use copy-paste special -
transpose.

Now each column, not multiple rows, hold a record (for one customer).

What should I do to get the records saved as CSV file?

Does MS access help here? Is there a better approach?

Thank you, my boss is demanding an answer.