How can I import a .csv that has two rows, the first is header, second is data, but creating one notes document per column?

HCL Domino Domino Forum
1

I am attempting to import a .csv file. I know how to do it if the file is set up with multiple rows like figure 1, but I have a file where there are only two rows, top being the header and 2nd being the data. figure2 - I need a separate document for each column, vs separate document for each row.

Figure 1

Header1 Header2 Header3

data1 data2 data3

data1 data2 data3

data1 data2 data3

Figure 2

Header1 Header2 Header3

data1 data2 data3

Any thoughts?

Thanks in advance…

2

Subject: I would import it into a spreadsheet and transpose it

Then save it as a new csv file and import into notes. Search Excel help for transpose on how to do that.

3

Subject: RE: I would import it into a spreadsheet and transpose it

Thanks - that is exactly what I just did and it worked great…