Re format csv data

[Danny54]

Good Afternoon

what would be the easiest way to convert the following data into a formatted excel worksheet? In a application that allows me to save the data as a csv I'm presented with the following opening the file.
In the days gone by we were able to import data based on double quotes and semicolons and excel would line up the data

source;"identifier";"owner";"data_tier";"device_type";"ip_addresses";"domain";"created_at"
inputfile;"solutions";"Johns";"";"Host";"192.20.20.15	192.20.20.16";"";"2022-05-03T01:00:00.602916-05:00"

The desired output would be a new sheet

A B C D E F G H
source identifier owner data_tier device_type ip_addresses domain created
inputfile solutions Johns Host 192.20.20.15, 192.20.20.16 2022-05-03T01:00:00.602916-05:00

Thanks

 

[Danny54]

A better output example

source	identifier	owner	data_tier	device_type	ip_addresses	domain	created
inputfile	solutions	Johns	Host		192.20.20.15, 192.20.20.16		2022-05-03T01:00:00.602916-05:00

 

[rlv01]

Have you tried the "Text to Columns" wizard found under the 'Data' menu?

 

[Danny54]

Yes, the data isnt moved correctly.

 

[rlv01]

Yes, the data isnt moved correctly.

Seems ok to me.

Before Wizard

Book1
	A
1	source;"identifier";"owner";"data_tier";"device_type";"ip_addresses";"domain";"created_at"
2	inputfile;"solutions";"Johns";"";"Host";"192.20.20.15,192.20.20.16";"";"2022-05-03T01:00:00.602916-05:00"
Sheet4

After Wizard

Book1
	A	B	C	D	E	F	G	H
1	source	identifier	owner	data_tier	device_type	ip_addresses	domain	created_at
2	inputfile	solutions	Johns		Host	192.20.20.15,192.20.20.16		2022-05-03T01:00:00.602916-05:00
3
Sheet4 (2)

 

[Danny54]

Thank you.