Forum Discussion
Pivot/Unpivot two columns by value
For reference i am only using one column (Cust ID). I feel like this isnt hard but i cant figure out how to get my column data into multiple rows. I have attached an image -- seems pretty straightfor...
Ashish_Mathur That helped me a lot. I was hoping this would help me with two columns instead of one. Any thoughts? I have a 3 rd column CustName which matches w a CustID. Is it possible to end up w columns such as: Zip(unique), CustName1, CustID1, CustName2, CustID2, CustName3, CustID3, etc.
You are welcome. I can get CustName1 ad CustID1 in one cell/column - not in different columns. May be someone else can help.