OraFAQ Forum: SQL & PL/SQL » Split Data in Column & Split Data in Excel (merged)

Home » SQL & PL/SQL » SQL & PL/SQL » Split Data in Column & Split Data in Excel (merged) (Excel 2016)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Split Data in Column & Split Data in Excel (merged) [message #671060]

Mon, 13 August 2018 12:53

vharish006
Messages: 70
Registered: August 2015
Location: Chicago

Member

Hi All,

I have an excel file with data which should be split.

Example:

Site ID Consortia/Multi-Site
-------- -------------------------
nci TAFE NSW Library
umac Inter Regional Consortium (IRC) P3-G2 (Primary), Hong Kong & Macau Consortium - 2014, Inter Regional Consortium (IRC)
P2-G2

Site_ID =Umac has corresponding Multisite with Comma Seprated Values.

I want to get the comma seperated values as different records but for same Site Id value. How can we do it?

I want to seperate them and upload to the table.

Uploaded the file for reference.Appreciate your help

Attachment: Book2.csv
(Size: 312.03KB, Downloaded 1590 times)

Report message to a moderator

[Message index]

		Split Data in Column & Split Data in Excel (merged) By: vharish006 on Mon, 13 August 2018 12:53
		Re: Split Data in Excel By: John Watson on Mon, 13 August 2018 12:56
		Re: Split Data in Excel By: Michel Cadot on Mon, 13 August 2018 13:10
		Re: Split Data in Excel By: Michel Cadot on Mon, 13 August 2018 13:42
		Re: Split Data in Excel By: vharish006 on Mon, 13 August 2018 13:53
		Split Data in Column By: vharish006 on Mon, 13 August 2018 13:26
		Re: Split Data in Column By: BlackSwan on Mon, 13 August 2018 13:34
		Re: Split Data in Column By: vharish006 on Mon, 13 August 2018 13:45

Previous Topic:	How to Convert Row to Column As Below
Next Topic:	XML Special Character

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Apr 19 14:44:05 CDT 2024