Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Not so strange. Just use the CrossTable function. See attached qvw.
Not so strange. Just use the CrossTable function. See attached qvw.
Oh, that was easy (as always)! Thanks