Forum Discussion
Append columns from 1 table for using in visual Slicer
Hi MykytYla
Please try this:
In the Power query, select the LE_address and Office_address column and click the Unpivot Columns in the Transform pane:
Then remove the Attribute column:
Change the name of the values column and the result is as follow:
Best Regards
Zhengdong Xu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Thank you for help.
I don't need Concat or merge, I need one column with both Addresses. But I don't want to creat table becouce I will not have a primary key
| Address | ||
| LA | Room | build. 121, Concord Pike, Wilmington, 19803, USA |
| LA | Room | build. 15841, University Drive, Newtown, 18940, USA |
| LA | Room | Carrera 43B, 16-95 |
| LA | Room | Padre Mariano 391 |
| NA | QP | build. 3647, Calle 10 BMadellinEdificio el Atico, Antioquia, Colombia |
| NA | QP | Huaxia Road, No. 147, Agile |
| OL | Vlog | 110 S Hartford Avenue, Suite 2 |
| OL | Vlog | build. 46, Del IncaEdificio Vitae, Las Condes, 7550000, Chile |
| QW | Share | build. 1, Little Falls Drive, Wilmington, 19808-1674, USA |
| QW | Share | build. 1, University Drive, Newtown, 18940, USA |
| QW | Share | Heroiv Dnipra, 4/2 |
| QW | Share | Zhibek Zholy, 135/10a |
| TR | Think | 11 Chang De Road, 15/F |
| TR | Think | build. 5, Degrees North Pilgrim Street, Newcastle, United Kingdom |
| TR | Think | build. 53, Churchill Place, London, , United Kingdom |
| TR | Think | Soho Limassol, 142nd floor, Anexartisias 187, Limassol 3040 |
| VA | Vait | 70 Hindmarsh Square |
| VA | Vait | build. 78, 7, Avda. Colón, Córdoba, X5000EPU, Argentina |
| VA | Vait | build. 78, Colón, Córdoba, X5000EPU, Argentina |
| VA | Vait | Serdara Jola Piletica 32 |
Hi MykytYla
Please try this:
In the Power query, select the LE_address and Office_address column and click the Unpivot Columns in the Transform pane:
Then remove the Attribute column:
Change the name of the values column and the result is as follow:
Best Regards
Zhengdong Xu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.