I have a very large table with data in a column which I want in rows instead.
The attached image shows the result I want. I manually copied the km from column C into columns E to J.
Columns E to J are the data from colmn B, which repeats exactly as shown all the way to the end of the spreadsheet.
That is all fine, but I have about 37000 rows to process.
I do not need columns B & C afterwards.
I do not need rows with nothing in E to J afterwards.
What options do you suggest?