Notifications
Clear all
VBA & Macros
3
Posts
2
Users
0
Reactions
58
Views
Topic starter
Hi,
Please can you help to Transpose some rows as below.
| Word | URL | Rank |
| maxim xl | https://www.syngenta.com.eg/product/crop-protection/maxim-xl | 1 |
| maxim xl | https://www.syngenta-us.com/seed-treatment/maxim-xl | 2 |
| maxim xl | https://www.syngenta.com.au/product/crop-protection/maxim-xl | 3 |
| maxim xl | https://www3.epa.gov/pesticides/chem_search/ppls/000100-00916-20110818.pdf | 4 |
| Imsje ej | https://www.facebook.com/e.j.images1/ | 1 |
| Imsje ej | https://www.facebook.com/e.j.images1/photos/ | 2 |
to be
Thanks;
Marsil
Posted : 25/05/2022 11:57 am
I would pivot the data in Power Query
let
Source = Excel.CurrentWorkbook(){[Name="Table1"]}[Content],
#"Pivoted Column" = Table.Pivot(Table.TransformColumnTypes(Source, {{"Rank", type text}}, "en-US"), List.Distinct(Table.TransformColumnTypes(Source, {{"Rank", type text}}, "en-US")[Rank]), "Rank", "URL")
in
#"Pivoted Column"
Posted : 26/05/2022 3:11 am
Topic starter
Hi Alan,
Wow! This is awesome and it works like a charm. Thank you so much!!!
Thanks,
Marsil
Posted : 27/05/2022 7:26 pm
