Exporting to CSV columns/rows

Hi

I have a simple spreadsheet with 4 columns A-D and a varying number of text rows in each column. I need to be able to export it into a CSV so that it puts each column on one comma separated line (in a text file). So it should look like this:

A1,A2,A3,A4...
B1,B2,B3,B4...
C1,C2,C3,C4...
D1,D2,D3,D4...

The problem is that when I select save as CSV it looks like this:
A1,B1,C1,D1
A2,B2,C2,D2

I know that I could rewrite the excel file in rows rather than columns but I would prefer the columns and I am an amature and know that it must be possible to achieve what I want without doing that!

Any help would be gratefully appreciated Thank you.

Hi Bobson,

See if this helps. Select the data and apply table formating ( format as table).

Now export as .csv. It should look like as you want



If you are satisfied with the solution(s) provided, please mark your thread as Solved.
Select Thread Tools-> Mark thread as Solved.

Click the star icon in the lower left part of the helper's post and add Reputation..

Hi elayaz.

Thank you for your reply but unfortunately it has not worked and the outcome remains the same.

Sorry for that. It's working correct for me. See attached files. If possible, export your excel file ( with dummy data), so that we can take a look.

Exporting to CSV_converted.csvExporting to CSV.xlsx