Forum Discussion
Unpivot Multiple Columns - Desktop
Hi bigdee008
Please check all the applied steps in Query Editor.The last step fill down can be used for other columns you need.
Regards,
Cherie
Community ChampionOK, well then this really comes down to how you want to combine the columns that you want to combine. So, for example, let's say you have columns A, B and C and you want a single column for them. What are the "rules"?
Because let's say you just want the sum of those in a column, you could create a new column:
D := [A] + [B] + [C]
Then you would delete columns A, B and C in the next step.
Thanks Greg.
So my situation is, simply put;
currently, i have Colums A ,B, C, D1, D2, D3, E1, E2, E3
I want to make the colums A, B, C, D, E. -- .i.e. all transaction data under D1 to D3 will go under D likewise for E1-E3 will go under E without losing their mapping.
Im so sorry If im not being clear enough :smileysad: