create table with two columns headers

[hash_89]

I have a data which looks something like this.

ID	Title	Subject	Value	Chapter	Weight-age
100	Scores	Maths	30	1	30
100	Scores	Maths	30	2	30
100	Scores	Maths	30	3	40
100	Scores	English	20	1	50
100	Scores	English	20	2	50
100	Scores	Chem	25	1	25
100	Scores	Chem	25	2	35
100	Scores	Chem	25	3	40
100	Scores	Physics	25	1	50
100	Scores	Physics	25	2	50

I would need to transform my data to cross tab to two columns as headers (Subject & Value)

			Maths	English	Chem	Physics
			30	20	25	25
ID	Title	Chapter
100	Scores	1	30	50	25	50
100	Scores	2	30	50	35	50
100	Scores	3	40		40

I tried doing cross tab in parallel for both the columns, but i am not sure how to bring it to 2 columns like shown above. Can someone help me with this?

[jamielaird · Accepted solution]

Hi @hash_89 ,

Two cross-tabs and a union tool with manually configured options will get you there or close enough, however this isn't a great way to structure your data as the subject values are now just 'floating' with no clear association to the rest of the data.

[hash_89]

Thankyou!