How to show 2 column values as column header instead of hierarchy in matrix/any other visualization?

[Jessica_17]

I have one column which is in table A.

id1

QRC

SRC

MRC

I have one column which is in table B.

id2

QRF

SRF

MRF

OUTPUT:-

COLUMN HEADER:- 

ID |QRC| QRF| SRC| SRF| MRC| MRF

EDIT: This is just an example, In real scenario, each column contains more than 40+ values.

I want this output scenario to happen automatically in column, not dynamically using transpose function.

[ryan_mayu · Accepted solution]

@Jessica_17 

not sure if this is what you want

in PQ, appendix two tables

transpose tables

user first row as header

pls see the attachment below

[ryan_mayu · Accepted solution]

@Jessica_17 

not sure if this is what you want

in PQ, appendix two tables

transpose tables

user first row as header

pls see the attachment below

[Jessica_17]

Yes, this is what I want, but I see you have converted it to columns using transpose and have selected each and every column to keep it in place,
But the question was an example, In future case I can have more than 40+ values in each column so instead of dynamically selecting that column, I want that it should happen automatically, all the column values should be shown as output columns without transposing it into various columns and selecting it.

[ryan_mayu]

@Jessica_17 

what about we just appendix data and put the new column in a matrix?

pls see the attachment below

[Jessica_17]

Thanks for the help,

I saw that column names are different, and I cannot change column names due to permission issues. and I edited the post accordingly.

[ryan_mayu]

so you want the output to change from id1 and id 2 to ID?

[Jessica_17]

Column name doesn't matter, column values matter in this situation.

[ryan_mayu]

not quite understand this request. you said column names are different in the previous post. what's the problem you are facing after you used the solution i provided?

[Jessica_17]

Column names are different , so it is being generated as 2 columns as shown in screenshot below

[ryan_mayu · Accepted solution]

what about merge two columns to get a new column and put that column to the matrix?

[Jessica_17]

Yes, It got solved thanks

[ryan_mayu]

you are welcome