Get 2 columns out of one in Excel spreadsheat

datatable
excel

#1

Hi,

I’m testing gathering data to a Excel spreadsheat. I get all the information I want to my xlsx (see attachment). The data is stored in a data table and then writes it to the xlsx .

image

How do i get the marked area from column 3 to a new column?
The table should look like this:

Car | Fuel capacity | Max speed | Avg.Consuption
Toyota Avensis | 60 l | 200 km/h | 7,5 l/100km

Thanks in advance for helping me.

Regards,
Mikael