This site uses different types of cookies, including analytics and functional cookies (its own and from other sites). To change your cookie settings or find out more, click here. If you continue browsing our website, you accept these cookies.
Looks like you just need to use a combination of the Transpose and Cross Tab Tools.
First Transpose with 'map' as a 'key field' and 'AAA', 'BBB',... as the 'data field'. Then send that into a Cross tab tool, grouping by 'Name' with 'map' as new column headers and 'Value' as Values for New Columns. See images below.