Custom Data Types in Excel

Yesterday, I demonstrated how to use Excel data types to give cell content richer meaning (lnkd.in/gA-MqQbZ).
Issues like erroneous and missing data damage their credibility though, and it's probably a big reason why Microsoft won't be renewing their Wolfram license, which ends on June 11, 2023.
Power Query custom data types offer an alternative that gives you greater control and flexibility. 𝘠𝘰𝘶 choose what data is stored instead of relying on a provider.
𝘛𝘩𝘪𝘴 𝘦𝘹𝘢𝘮𝘱𝘭𝘦 𝘦𝘹𝘵𝘳𝘢𝘤𝘵𝘴 𝘗𝘳𝘦𝘮𝘪𝘦𝘳 𝘓𝘦𝘢𝘨𝘶𝘦 𝘤𝘭𝘶𝘣 𝘥𝘢𝘵𝘢 𝘧𝘳𝘰𝘮 𝘞𝘪𝘬𝘪𝘱𝘦𝘥𝘪𝘢 𝘧𝘰𝘳 𝘵𝘩𝘦 2022/23 𝘴𝘦𝘢𝘴𝘰𝘯.
𝗦𝘁𝗲𝗽𝘀
1. Select Data (tab) ＞ Get & Transform Data (group) ＞ From Web (button).
2. Paste ' en. wikipedia. org/wiki/2022%E2%80%9323_Premier_League' as the URL and click OK.
3. Double-click the Personnel and kits[edit] item to open the Power Query Editor.
4. Click on the first column and then press Ctrl + A to select all of them.
5. Select Transform (tab) ＞ Structured Column (group) ＞ Create Data Type (button) to open the Create Data Type window.
6. Type 'Premier League Teams' for the Data type name and click OK.
7. Select Home (tab) ＞ Close & Load (button) to load the table into a new worksheet.
8. Activate A2 and click the in-cell Show card button.
9. Click the Extract to grid button next to each field (apart from Team) to add them to the table.
Currently, there is no way of storing images, but I'm sure it won't be long before we can.
#excel #exceltips #excelskills
---
Where to find me:
LinkedIn - / andrewcharlesmoss
Medium - / andrewcharlesmoss
GitHub - github.com/and...
Twitter - / andrew_c_moss
Facebook - / andrewcharlesmoss
Donations:
PayPal - www.paypal.com...
Buy Me a Coffee - www.buymeacoff...