Strange transpose - help needed :)

[#1]

Hi all

I have a table that looks like this:

Header 1	Header 2	Header 3	Header 4	Header 5
Data 1	Data 21	Data 31	Data 41	Data 51
Data 2	Data 22	Data 32	Data 42	Data 52
Data 3		Data 33		Data 53
		Data 34		Data 54

My goal is to create a table that looks like this:

MainProcess	Activity
Header 1	Data 1
Header 1	Data 2
Header 1	Data 3
Header 2	Data 21
Header 2	Data 22
Header 3	Data 31
Header 3	Data 32
Header 3	Data 33
Header 3	Data 34
And so on....

Any advice would be much appriciated

Regards

Trond Erik

[Gysbert_Wassenaar · Accepted solution]

Not so strange. Just use the CrossTable function. See attached qvw.

[#3]

Oh, that was easy (as always)! Thanks