Separate values in single cell to header and values

[koppals1]

Hello All,

I want to split single column data to multiple rows. Below is the sample input data

[Class A]

Maths=100

Science=90

English=80

Social=85

[Class B]

Maths=90

Science=95

English=86

Social=95

[Class C]

Maths=70

Science=65

English=76

Social=75

Expected Output

	Maths	Science	English	Social
CLASS A	100	90	80	85
CLASS B	90	95	86	95
CLASS C	70	65	76	75

[Bren_Spill · Accepted solution]

@koppals1 - see attached. 

Multi-Row is used to tag each record with the correct Class. It's important to have this data in rows as you need to group on it in the Cross Tab tool. Text to columns splits your subject and result into columns, and finally Cross-Tab creates the output you need by moving the subject into your field name

[koppals1]

It works, thanks for the solution