Spreadsheet to CSV

[Noip]

Hi all

I want to convert the following data (spreadsheet);

Column1 Column2
row1: dataA1
row2: dataA2 dataA3
row3: dataA4 dataA5
row4: dataA6
row5: dataB1
row6: dataB2 dataB3
row7: dataB4 dataB5
row8: dataB6

into CSV
where the data will

"dataA1","dataA6"
"dataB1","dataB6"

Any suggestion

 

[dhulbert]

File-SaveAs and select CSV(Comma Delimited)

Easy as that.

 

[Noip]

Yes,

but I need the format:

"dataA1","dataA6"
"dataB1","dataB6"

in CSV

 

[ssf]

You will need to use Sheet2, with cells with formulas = to the cells you want to pick up from Sheet1 in the order you wish to save them to csv

Sheet 2
Row1 Col1 value =sheet1!a1 Row1 Col2 =sheet1!a4
Row2 Col1 value =Sheet1!a5 Row2 Col2 =Sheet1!a8

etc. Until Sheet2 has the values in the format which you want to save to the csv file.
Then, save the Sheet2 as a csv file.