SharePoint rows into column

[Jayant2]

Hi All,

I have a business requirement to SharePoint column data divided into multiple rows by project.

Example: 

Project Name	IT Lead	Date	Text column
ABCD	ABCD		ABCD
XYZ	XYZ

Now based on the above data i want to create a collection that displays data in the below format.
severity is assigned as per column. So for date if it is blank severity 3 will be provided and if text column is blank then severity should be 5.

Project Name	IT Lead	Column	Severity
ABCD	ABCD	Date is blank	3
XYZ	XYZ	date is blank	3
XYZ	XYZ	Text is blank	5

How can I accomplish this?

Thanks in advance!

[Jayant2]

@v-bofeng-msft i have completed this requirement through multiple if condition and Patch method that patches the record to a collection and thus i am using that collection to view the data.

Thanks for your input.

[v-bofeng-msft]

Hi @Jayant2 :

Thanks for your feedback.

I'm glad to hear that you have solved this problem.

Best Regards,

Bof

[Jayant2]

@v-bofeng-msft actually i need help with one issue. I have posted the question but no feasible solution found for it.

Link to the question:

Extract Datetime from string 

it would be great if you could help me out in this please.