I have copied and pasted historic interest rates from http://www.loansense.com.au/historical-rates.html into notepad++
I want to get it into a spreadsheet. Calc.
It comes as one long column in Notepad++. I can select a section and Ctrl-J makes that a row.
Then the next selection the same.
That give column headers and the data for each column.
But they're different sizes. Different number of character headers and data.
They don't match up.
How should I do this operation?