(Forum) PQ: In Kommaseparierter Spalte Werte aus anderem Tabellenblatt ersetzen

Quelle:  https://www.herber.de/cgi-bin/eachthread.pl?idx=1993970
Stand: 16.10.2024 16:55

Bitte beacht­en Sie die hier beschriebene Beson­der­heit in Sachen des Her­ber-Forums.

Off top­ic: Immer öfter frage ich mich, welche Ansprüche doch manch ein Fragesteller an die Helfer in Excel-Foren haben und mit welchem Selb­stver­ständ­nis für ein kom­merzielles Umfeld uneingeschränk­te, diener­isch buck­el­nde Hil­fe zum Null­tarif erwartet oder gefordert wird. 🙁 Hier ste­he ich voll und ganz hin­ter dem Beitrag von Onur (16.10.2024 14:50:38), auch wenn seine vorheri­gen Anmerkun­gen in diesen Thread vielle­icht etwas „reißerisch“ waren.

Zum eigentlichen The­ma: Ich finde, dass hier Pow­er Query einen wesentlich „trans­par­enteren“ Weg zum Ziel anbi­etet. Zugegeben, ein händis­ch­er Ein­griff ist erforder­lich, wo eine durch PQ gener­ierte Formel an 2 Posi­tio­nen geän­dert bzw. angepasst wer­den muss. Aber so kann auf „Insider“-Funktionalitäten verzichtet wer­den und das funk­tion­iert auch mit Excel-Ver­sio­nen, die deut­lich älter sind als 365 bzw. 2021. Hier mein M-Code für die bei­den Arbeits­blät­ter:

Die Artikel-IDs

let
    Quelle = Excel.CurrentWorkbook(){[Name="Atikel_ID"]}[Content],
    #"Geänderter Typ" = Table.TransformColumnTypes(Quelle,{{"Artikelnummer", Int64.Type}, {"Artikel-ID", Int64.Type}})
in
    #"Geänderter Typ"

Pro­duk­t­dat­en – Aus­tausch der Artikel­num­mer

let
    Quelle = Excel.CurrentWorkbook(){[Name="ArtikelNummer_CS"]}[Content],
    #"Geänderter Typ" = Table.TransformColumnTypes(Quelle,{{"EAN", type text}}),
    #"Spalte nach Trennzeichen teilen" = Table.SplitColumn(#"Geänderter Typ", "Cross-Selling", Splitter.SplitTextByDelimiter(",", QuoteStyle.csv), {"Cross-Selling.1", "Cross-Selling.2", "Cross-Selling.3", "Cross-Selling.4", "Cross-Selling.5", "Cross-Selling.6", "Cross-Selling.7", "Cross-Selling.8", "Cross-Selling.9", "Cross-Selling.10", "Cross-Selling.11", "Cross-Selling.12", "Cross-Selling.13", "Cross-Selling.14", "Cross-Selling.15", "Cross-Selling.16", "Cross-Selling.17", "Cross-Selling.18", "Cross-Selling.19", "Cross-Selling.20", "Cross-Selling.21", "Cross-Selling.22", "Cross-Selling.23", "Cross-Selling.24", "Cross-Selling.25", "Cross-Selling.26", "Cross-Selling.27", "Cross-Selling.28", "Cross-Selling.29", "Cross-Selling.30", "Cross-Selling.31", "Cross-Selling.32", "Cross-Selling.33", "Cross-Selling.34", "Cross-Selling.35", "Cross-Selling.36", "Cross-Selling.37", "Cross-Selling.38", "Cross-Selling.39", "Cross-Selling.40", "Cross-Selling.41", "Cross-Selling.42", "Cross-Selling.43", "Cross-Selling.44", "Cross-Selling.45", "Cross-Selling.46", "Cross-Selling.47", "Cross-Selling.48", "Cross-Selling.49", "Cross-Selling.50", "Cross-Selling.51", "Cross-Selling.52", "Cross-Selling.53", "Cross-Selling.54", "Cross-Selling.55", "Cross-Selling.56", "Cross-Selling.57", "Cross-Selling.58", "Cross-Selling.59", "Cross-Selling.60", "Cross-Selling.61", "Cross-Selling.62", "Cross-Selling.63", "Cross-Selling.64", "Cross-Selling.65", "Cross-Selling.66", "Cross-Selling.67", "Cross-Selling.68", "Cross-Selling.69", "Cross-Selling.70", "Cross-Selling.71", "Cross-Selling.72", "Cross-Selling.73", "Cross-Selling.74", "Cross-Selling.75", "Cross-Selling.76", "Cross-Selling.77", "Cross-Selling.78", "Cross-Selling.79", "Cross-Selling.80", "Cross-Selling.81", "Cross-Selling.82", "Cross-Selling.83", "Cross-Selling.84", "Cross-Selling.85", "Cross-Selling.86", "Cross-Selling.87", "Cross-Selling.88", "Cross-Selling.89", "Cross-Selling.90", "Cross-Selling.91", "Cross-Selling.92", "Cross-Selling.93", "Cross-Selling.94", "Cross-Selling.95", "Cross-Selling.96", "Cross-Selling.97", "Cross-Selling.98", "Cross-Selling.99", "Cross-Selling.100", "Cross-Selling.101", "Cross-Selling.102", "Cross-Selling.103", "Cross-Selling.104", "Cross-Selling.105", "Cross-Selling.106", "Cross-Selling.107", "Cross-Selling.108", "Cross-Selling.109", "Cross-Selling.110", "Cross-Selling.111", "Cross-Selling.112", "Cross-Selling.113", "Cross-Selling.114", "Cross-Selling.115", "Cross-Selling.116", "Cross-Selling.117", "Cross-Selling.118", "Cross-Selling.119", "Cross-Selling.120", "Cross-Selling.121", "Cross-Selling.122", "Cross-Selling.123", "Cross-Selling.124", "Cross-Selling.125", "Cross-Selling.126", "Cross-Selling.127", "Cross-Selling.128", "Cross-Selling.129", "Cross-Selling.130", "Cross-Selling.131", "Cross-Selling.132", "Cross-Selling.133", "Cross-Selling.134", "Cross-Selling.135", "Cross-Selling.136", "Cross-Selling.137", "Cross-Selling.138", "Cross-Selling.139", "Cross-Selling.140", "Cross-Selling.141", "Cross-Selling.142", "Cross-Selling.143", "Cross-Selling.144", "Cross-Selling.145", "Cross-Selling.146", "Cross-Selling.147", "Cross-Selling.148", "Cross-Selling.149", "Cross-Selling.150", "Cross-Selling.151", "Cross-Selling.152", "Cross-Selling.153", "Cross-Selling.154", "Cross-Selling.155", "Cross-Selling.156", "Cross-Selling.157", "Cross-Selling.158", "Cross-Selling.159", "Cross-Selling.160", "Cross-Selling.161", "Cross-Selling.162", "Cross-Selling.163", "Cross-Selling.164", "Cross-Selling.165", "Cross-Selling.166", "Cross-Selling.167", "Cross-Selling.168", "Cross-Selling.169", "Cross-Selling.170", "Cross-Selling.171", "Cross-Selling.172", "Cross-Selling.173", "Cross-Selling.174", "Cross-Selling.175", "Cross-Selling.176", "Cross-Selling.177", "Cross-Selling.178", "Cross-Selling.179", "Cross-Selling.180", "Cross-Selling.181", "Cross-Selling.182", "Cross-Selling.183", "Cross-Selling.184", "Cross-Selling.185", "Cross-Selling.186", "Cross-Selling.187", "Cross-Selling.188", "Cross-Selling.189", "Cross-Selling.190", "Cross-Selling.191", "Cross-Selling.192", "Cross-Selling.193", "Cross-Selling.194", "Cross-Selling.195", "Cross-Selling.196", "Cross-Selling.197", "Cross-Selling.198", "Cross-Selling.199", "Cross-Selling.200", "Cross-Selling.201", "Cross-Selling.202", "Cross-Selling.203", "Cross-Selling.204", "Cross-Selling.205", "Cross-Selling.206", "Cross-Selling.207", "Cross-Selling.208", "Cross-Selling.209", "Cross-Selling.210", "Cross-Selling.211", "Cross-Selling.212", "Cross-Selling.213", "Cross-Selling.214", "Cross-Selling.215", "Cross-Selling.216", "Cross-Selling.217", "Cross-Selling.218", "Cross-Selling.219", "Cross-Selling.220", "Cross-Selling.221", "Cross-Selling.222", "Cross-Selling.223", "Cross-Selling.224", "Cross-Selling.225", "Cross-Selling.226", "Cross-Selling.227", "Cross-Selling.228", "Cross-Selling.229", "Cross-Selling.230", "Cross-Selling.231", "Cross-Selling.232", "Cross-Selling.233", "Cross-Selling.234", "Cross-Selling.235", "Cross-Selling.236", "Cross-Selling.237", "Cross-Selling.238", "Cross-Selling.239", "Cross-Selling.240", "Cross-Selling.241", "Cross-Selling.242", "Cross-Selling.243", "Cross-Selling.244", "Cross-Selling.245", "Cross-Selling.246", "Cross-Selling.247", "Cross-Selling.248", "Cross-Selling.249", "Cross-Selling.250", "Cross-Selling.251", "Cross-Selling.252", "Cross-Selling.253", "Cross-Selling.254", "Cross-Selling.255", "Cross-Selling.256", "Cross-Selling.257", "Cross-Selling.258", "Cross-Selling.259", "Cross-Selling.260", "Cross-Selling.261", "Cross-Selling.262", "Cross-Selling.263", "Cross-Selling.264", "Cross-Selling.265", "Cross-Selling.266", "Cross-Selling.267", "Cross-Selling.268", "Cross-Selling.269", "Cross-Selling.270", "Cross-Selling.271", "Cross-Selling.272", "Cross-Selling.273", "Cross-Selling.274", "Cross-Selling.275", "Cross-Selling.276", "Cross-Selling.277", "Cross-Selling.278", "Cross-Selling.279", "Cross-Selling.280", "Cross-Selling.281", "Cross-Selling.282", "Cross-Selling.283", "Cross-Selling.284", "Cross-Selling.285", "Cross-Selling.286", "Cross-Selling.287", "Cross-Selling.288", "Cross-Selling.289", "Cross-Selling.290", "Cross-Selling.291", "Cross-Selling.292", "Cross-Selling.293", "Cross-Selling.294", "Cross-Selling.295", "Cross-Selling.296", "Cross-Selling.297", "Cross-Selling.298", "Cross-Selling.299", "Cross-Selling.300", "Cross-Selling.301", "Cross-Selling.302", "Cross-Selling.303", "Cross-Selling.304", "Cross-Selling.305", "Cross-Selling.306", "Cross-Selling.307", "Cross-Selling.308", "Cross-Selling.309", "Cross-Selling.310", "Cross-Selling.311", "Cross-Selling.312", "Cross-Selling.313", "Cross-Selling.314", "Cross-Selling.315", "Cross-Selling.316", "Cross-Selling.317", "Cross-Selling.318", "Cross-Selling.319", "Cross-Selling.320", "Cross-Selling.321", "Cross-Selling.322", "Cross-Selling.323", "Cross-Selling.324", "Cross-Selling.325", "Cross-Selling.326", "Cross-Selling.327", "Cross-Selling.328", "Cross-Selling.329", "Cross-Selling.330", "Cross-Selling.331", "Cross-Selling.332", "Cross-Selling.333", "Cross-Selling.334", "Cross-Selling.335", "Cross-Selling.336", "Cross-Selling.337", "Cross-Selling.338", "Cross-Selling.339", "Cross-Selling.340", "Cross-Selling.341", "Cross-Selling.342", "Cross-Selling.343", "Cross-Selling.344", "Cross-Selling.345", "Cross-Selling.346", "Cross-Selling.347", "Cross-Selling.348", "Cross-Selling.349", "Cross-Selling.350", "Cross-Selling.351", "Cross-Selling.352", "Cross-Selling.353", "Cross-Selling.354", "Cross-Selling.355", "Cross-Selling.356", "Cross-Selling.357", "Cross-Selling.358", "Cross-Selling.359", "Cross-Selling.360", "Cross-Selling.361", "Cross-Selling.362", "Cross-Selling.363", "Cross-Selling.364", "Cross-Selling.365", "Cross-Selling.366", "Cross-Selling.367", "Cross-Selling.368", "Cross-Selling.369", "Cross-Selling.370", "Cross-Selling.371", "Cross-Selling.372", "Cross-Selling.373", "Cross-Selling.374", "Cross-Selling.375", "Cross-Selling.376", "Cross-Selling.377", "Cross-Selling.378", "Cross-Selling.379", "Cross-Selling.380", "Cross-Selling.381", "Cross-Selling.382", "Cross-Selling.383", "Cross-Selling.384", "Cross-Selling.385", "Cross-Selling.386", "Cross-Selling.387", "Cross-Selling.388", "Cross-Selling.389", "Cross-Selling.390", "Cross-Selling.391", "Cross-Selling.392", "Cross-Selling.393", "Cross-Selling.394", "Cross-Selling.395", "Cross-Selling.396", "Cross-Selling.397", "Cross-Selling.398", "Cross-Selling.399", "Cross-Selling.400", "Cross-Selling.401", "Cross-Selling.402", "Cross-Selling.403", "Cross-Selling.404", "Cross-Selling.405", "Cross-Selling.406", "Cross-Selling.407", "Cross-Selling.408", "Cross-Selling.409", "Cross-Selling.410", "Cross-Selling.411", "Cross-Selling.412", "Cross-Selling.413", "Cross-Selling.414", "Cross-Selling.415", "Cross-Selling.416", "Cross-Selling.417", "Cross-Selling.418", "Cross-Selling.419", "Cross-Selling.420", "Cross-Selling.421", "Cross-Selling.422", "Cross-Selling.423", "Cross-Selling.424", "Cross-Selling.425", "Cross-Selling.426", "Cross-Selling.427", "Cross-Selling.428", "Cross-Selling.429", "Cross-Selling.430", "Cross-Selling.431", "Cross-Selling.432", "Cross-Selling.433", "Cross-Selling.434", "Cross-Selling.435", "Cross-Selling.436", "Cross-Selling.437", "Cross-Selling.438", "Cross-Selling.439", "Cross-Selling.440", "Cross-Selling.441", "Cross-Selling.442", "Cross-Selling.443", "Cross-Selling.444", "Cross-Selling.445", "Cross-Selling.446", "Cross-Selling.447", "Cross-Selling.448", "Cross-Selling.449", "Cross-Selling.450", "Cross-Selling.451", "Cross-Selling.452", "Cross-Selling.453", "Cross-Selling.454", "Cross-Selling.455", "Cross-Selling.456", "Cross-Selling.457", "Cross-Selling.458", "Cross-Selling.459", "Cross-Selling.460", "Cross-Selling.461", "Cross-Selling.462", "Cross-Selling.463", "Cross-Selling.464", "Cross-Selling.465", "Cross-Selling.466", "Cross-Selling.467", "Cross-Selling.468", "Cross-Selling.469", "Cross-Selling.470", "Cross-Selling.471", "Cross-Selling.472", "Cross-Selling.473", "Cross-Selling.474", "Cross-Selling.475", "Cross-Selling.476", "Cross-Selling.477", "Cross-Selling.478", "Cross-Selling.479", "Cross-Selling.480", "Cross-Selling.481", "Cross-Selling.482", "Cross-Selling.483", "Cross-Selling.484", "Cross-Selling.485", "Cross-Selling.486", "Cross-Selling.487", "Cross-Selling.488", "Cross-Selling.489", "Cross-Selling.490", "Cross-Selling.491", "Cross-Selling.492", "Cross-Selling.493", "Cross-Selling.494", "Cross-Selling.495", "Cross-Selling.496", "Cross-Selling.497", "Cross-Selling.498", "Cross-Selling.499", "Cross-Selling.500", "Cross-Selling.501", "Cross-Selling.502", "Cross-Selling.503", "Cross-Selling.504", "Cross-Selling.505", "Cross-Selling.506", "Cross-Selling.507", "Cross-Selling.508", "Cross-Selling.509", "Cross-Selling.510", "Cross-Selling.511", "Cross-Selling.512", "Cross-Selling.513", "Cross-Selling.514", "Cross-Selling.515", "Cross-Selling.516", "Cross-Selling.517", "Cross-Selling.518", "Cross-Selling.519", "Cross-Selling.520", "Cross-Selling.521", "Cross-Selling.522", "Cross-Selling.523", "Cross-Selling.524", "Cross-Selling.525", "Cross-Selling.526", "Cross-Selling.527", "Cross-Selling.528", "Cross-Selling.529", "Cross-Selling.530", "Cross-Selling.531", "Cross-Selling.532", "Cross-Selling.533", "Cross-Selling.534", "Cross-Selling.535", "Cross-Selling.536", "Cross-Selling.537", "Cross-Selling.538", "Cross-Selling.539", "Cross-Selling.540", "Cross-Selling.541", "Cross-Selling.542", "Cross-Selling.543", "Cross-Selling.544", "Cross-Selling.545", "Cross-Selling.546", "Cross-Selling.547", "Cross-Selling.548", "Cross-Selling.549", "Cross-Selling.550", "Cross-Selling.551", "Cross-Selling.552", "Cross-Selling.553", "Cross-Selling.554", "Cross-Selling.555", "Cross-Selling.556", "Cross-Selling.557", "Cross-Selling.558", "Cross-Selling.559", "Cross-Selling.560", "Cross-Selling.561", "Cross-Selling.562", "Cross-Selling.563", "Cross-Selling.564", "Cross-Selling.565", "Cross-Selling.566", "Cross-Selling.567", "Cross-Selling.568", "Cross-Selling.569", "Cross-Selling.570", "Cross-Selling.571", "Cross-Selling.572", "Cross-Selling.573", "Cross-Selling.574", "Cross-Selling.575", "Cross-Selling.576", "Cross-Selling.577", "Cross-Selling.578", "Cross-Selling.579", "Cross-Selling.580", "Cross-Selling.581", "Cross-Selling.582", "Cross-Selling.583", "Cross-Selling.584", "Cross-Selling.585", "Cross-Selling.586", "Cross-Selling.587", "Cross-Selling.588", "Cross-Selling.589", "Cross-Selling.590", "Cross-Selling.591", "Cross-Selling.592", "Cross-Selling.593", "Cross-Selling.594", "Cross-Selling.595", "Cross-Selling.596", "Cross-Selling.597", "Cross-Selling.598", "Cross-Selling.599", "Cross-Selling.600", "Cross-Selling.601", "Cross-Selling.602", "Cross-Selling.603", "Cross-Selling.604", "Cross-Selling.605", "Cross-Selling.606", "Cross-Selling.607", "Cross-Selling.608", "Cross-Selling.609", "Cross-Selling.610", "Cross-Selling.611", "Cross-Selling.612", "Cross-Selling.613", "Cross-Selling.614", "Cross-Selling.615", "Cross-Selling.616", "Cross-Selling.617", "Cross-Selling.618", "Cross-Selling.619", "Cross-Selling.620", "Cross-Selling.621", "Cross-Selling.622", "Cross-Selling.623", "Cross-Selling.624", "Cross-Selling.625", "Cross-Selling.626", "Cross-Selling.627", "Cross-Selling.628", "Cross-Selling.629", "Cross-Selling.630", "Cross-Selling.631", "Cross-Selling.632", "Cross-Selling.633", "Cross-Selling.634", "Cross-Selling.635", "Cross-Selling.636", "Cross-Selling.637", "Cross-Selling.638", "Cross-Selling.639", "Cross-Selling.640", "Cross-Selling.641", "Cross-Selling.642", "Cross-Selling.643", "Cross-Selling.644", "Cross-Selling.645", "Cross-Selling.646", "Cross-Selling.647", "Cross-Selling.648", "Cross-Selling.649", "Cross-Selling.650", "Cross-Selling.651", "Cross-Selling.652", "Cross-Selling.653", "Cross-Selling.654", "Cross-Selling.655", "Cross-Selling.656", "Cross-Selling.657", "Cross-Selling.658", "Cross-Selling.659", "Cross-Selling.660", "Cross-Selling.661", "Cross-Selling.662", "Cross-Selling.663", "Cross-Selling.664", "Cross-Selling.665", "Cross-Selling.666", "Cross-Selling.667", "Cross-Selling.668", "Cross-Selling.669", "Cross-Selling.670", "Cross-Selling.671", "Cross-Selling.672", "Cross-Selling.673", "Cross-Selling.674", "Cross-Selling.675", "Cross-Selling.676", "Cross-Selling.677", "Cross-Selling.678", "Cross-Selling.679", "Cross-Selling.680", "Cross-Selling.681", "Cross-Selling.682", "Cross-Selling.683", "Cross-Selling.684"}),
    #"Geänderter Typ1" = Table.TransformColumnTypes(#"Spalte nach Trennzeichen teilen",{{"Cross-Selling.1", Int64.Type}, {"Cross-Selling.2", Int64.Type}, {"Cross-Selling.3", Int64.Type}, {"Cross-Selling.4", Int64.Type}, {"Cross-Selling.5", Int64.Type}, {"Cross-Selling.6", Int64.Type}, {"Cross-Selling.7", Int64.Type}, {"Cross-Selling.8", Int64.Type}, {"Cross-Selling.9", Int64.Type}, {"Cross-Selling.10", Int64.Type}, {"Cross-Selling.11", Int64.Type}, {"Cross-Selling.12", Int64.Type}, {"Cross-Selling.13", Int64.Type}, {"Cross-Selling.14", Int64.Type}, {"Cross-Selling.15", Int64.Type}, {"Cross-Selling.16", Int64.Type}, {"Cross-Selling.17", Int64.Type}, {"Cross-Selling.18", Int64.Type}, {"Cross-Selling.19", Int64.Type}, {"Cross-Selling.20", Int64.Type}, {"Cross-Selling.21", Int64.Type}, {"Cross-Selling.22", Int64.Type}, {"Cross-Selling.23", Int64.Type}, {"Cross-Selling.24", Int64.Type}, {"Cross-Selling.25", Int64.Type}, {"Cross-Selling.26", Int64.Type}, {"Cross-Selling.27", Int64.Type}, {"Cross-Selling.28", Int64.Type}, {"Cross-Selling.29", Int64.Type}, {"Cross-Selling.30", Int64.Type}, {"Cross-Selling.31", Int64.Type}, {"Cross-Selling.32", Int64.Type}, {"Cross-Selling.33", Int64.Type}, {"Cross-Selling.34", Int64.Type}, {"Cross-Selling.35", Int64.Type}, {"Cross-Selling.36", Int64.Type}, {"Cross-Selling.37", Int64.Type}, {"Cross-Selling.38", Int64.Type}, {"Cross-Selling.39", Int64.Type}, {"Cross-Selling.40", Int64.Type}, {"Cross-Selling.41", Int64.Type}, {"Cross-Selling.42", Int64.Type}, {"Cross-Selling.43", Int64.Type}, {"Cross-Selling.44", Int64.Type}, {"Cross-Selling.45", Int64.Type}, {"Cross-Selling.46", Int64.Type}, {"Cross-Selling.47", Int64.Type}, {"Cross-Selling.48", Int64.Type}, {"Cross-Selling.49", Int64.Type}, {"Cross-Selling.50", Int64.Type}, {"Cross-Selling.51", Int64.Type}, {"Cross-Selling.52", Int64.Type}, {"Cross-Selling.53", Int64.Type}, {"Cross-Selling.54", Int64.Type}, {"Cross-Selling.55", Int64.Type}, {"Cross-Selling.56", Int64.Type}, {"Cross-Selling.57", Int64.Type}, {"Cross-Selling.58", Int64.Type}, {"Cross-Selling.59", Int64.Type}, {"Cross-Selling.60", Int64.Type}, {"Cross-Selling.61", Int64.Type}, {"Cross-Selling.62", Int64.Type}, {"Cross-Selling.63", Int64.Type}, {"Cross-Selling.64", Int64.Type}, {"Cross-Selling.65", Int64.Type}, {"Cross-Selling.66", Int64.Type}, {"Cross-Selling.67", Int64.Type}, {"Cross-Selling.68", Int64.Type}, {"Cross-Selling.69", Int64.Type}, {"Cross-Selling.70", Int64.Type}, {"Cross-Selling.71", Int64.Type}, {"Cross-Selling.72", Int64.Type}, {"Cross-Selling.73", Int64.Type}, {"Cross-Selling.74", Int64.Type}, {"Cross-Selling.75", Int64.Type}, {"Cross-Selling.76", Int64.Type}, {"Cross-Selling.77", Int64.Type}, {"Cross-Selling.78", Int64.Type}, {"Cross-Selling.79", Int64.Type}, {"Cross-Selling.80", Int64.Type}, {"Cross-Selling.81", Int64.Type}, {"Cross-Selling.82", Int64.Type}, {"Cross-Selling.83", Int64.Type}, {"Cross-Selling.84", Int64.Type}, {"Cross-Selling.85", Int64.Type}, {"Cross-Selling.86", Int64.Type}, {"Cross-Selling.87", Int64.Type}, {"Cross-Selling.88", Int64.Type}, {"Cross-Selling.89", Int64.Type}, {"Cross-Selling.90", Int64.Type}, {"Cross-Selling.91", Int64.Type}, {"Cross-Selling.92", Int64.Type}, {"Cross-Selling.93", Int64.Type}, {"Cross-Selling.94", Int64.Type}, {"Cross-Selling.95", Int64.Type}, {"Cross-Selling.96", Int64.Type}, {"Cross-Selling.97", Int64.Type}, {"Cross-Selling.98", Int64.Type}, {"Cross-Selling.99", Int64.Type}, {"Cross-Selling.100", Int64.Type}, {"Cross-Selling.101", Int64.Type}, {"Cross-Selling.102", Int64.Type}, {"Cross-Selling.103", Int64.Type}, {"Cross-Selling.104", Int64.Type}, {"Cross-Selling.105", Int64.Type}, {"Cross-Selling.106", Int64.Type}, {"Cross-Selling.107", Int64.Type}, {"Cross-Selling.108", Int64.Type}, {"Cross-Selling.109", Int64.Type}, {"Cross-Selling.110", Int64.Type}, {"Cross-Selling.111", Int64.Type}, {"Cross-Selling.112", Int64.Type}, {"Cross-Selling.113", Int64.Type}, {"Cross-Selling.114", Int64.Type}, {"Cross-Selling.115", Int64.Type}, {"Cross-Selling.116", Int64.Type}, {"Cross-Selling.117", Int64.Type}, {"Cross-Selling.118", Int64.Type}, {"Cross-Selling.119", Int64.Type}, {"Cross-Selling.120", Int64.Type}, {"Cross-Selling.121", Int64.Type}, {"Cross-Selling.122", Int64.Type}, {"Cross-Selling.123", Int64.Type}, {"Cross-Selling.124", Int64.Type}, {"Cross-Selling.125", Int64.Type}, {"Cross-Selling.126", Int64.Type}, {"Cross-Selling.127", Int64.Type}, {"Cross-Selling.128", Int64.Type}, {"Cross-Selling.129", Int64.Type}, {"Cross-Selling.130", Int64.Type}, {"Cross-Selling.131", Int64.Type}, {"Cross-Selling.132", Int64.Type}, {"Cross-Selling.133", Int64.Type}, {"Cross-Selling.134", Int64.Type}, {"Cross-Selling.135", Int64.Type}, {"Cross-Selling.136", Int64.Type}, {"Cross-Selling.137", Int64.Type}, {"Cross-Selling.138", Int64.Type}, {"Cross-Selling.139", Int64.Type}, {"Cross-Selling.140", Int64.Type}, {"Cross-Selling.141", Int64.Type}, {"Cross-Selling.142", Int64.Type}, {"Cross-Selling.143", Int64.Type}, {"Cross-Selling.144", Int64.Type}, {"Cross-Selling.145", Int64.Type}, {"Cross-Selling.146", Int64.Type}, {"Cross-Selling.147", Int64.Type}, {"Cross-Selling.148", Int64.Type}, {"Cross-Selling.149", Int64.Type}, {"Cross-Selling.150", Int64.Type}, {"Cross-Selling.151", Int64.Type}, {"Cross-Selling.152", Int64.Type}, {"Cross-Selling.153", Int64.Type}, {"Cross-Selling.154", Int64.Type}, {"Cross-Selling.155", Int64.Type}, {"Cross-Selling.156", Int64.Type}, {"Cross-Selling.157", Int64.Type}, {"Cross-Selling.158", Int64.Type}, {"Cross-Selling.159", Int64.Type}, {"Cross-Selling.160", Int64.Type}, {"Cross-Selling.161", Int64.Type}, {"Cross-Selling.162", Int64.Type}, {"Cross-Selling.163", Int64.Type}, {"Cross-Selling.164", Int64.Type}, {"Cross-Selling.165", Int64.Type}, {"Cross-Selling.166", Int64.Type}, {"Cross-Selling.167", Int64.Type}, {"Cross-Selling.168", Int64.Type}, {"Cross-Selling.169", Int64.Type}, {"Cross-Selling.170", Int64.Type}, {"Cross-Selling.171", Int64.Type}, {"Cross-Selling.172", Int64.Type}, {"Cross-Selling.173", Int64.Type}, {"Cross-Selling.174", Int64.Type}, {"Cross-Selling.175", Int64.Type}, {"Cross-Selling.176", Int64.Type}, {"Cross-Selling.177", Int64.Type}, {"Cross-Selling.178", Int64.Type}, {"Cross-Selling.179", Int64.Type}, {"Cross-Selling.180", Int64.Type}, {"Cross-Selling.181", Int64.Type}, {"Cross-Selling.182", Int64.Type}, {"Cross-Selling.183", Int64.Type}, {"Cross-Selling.184", Int64.Type}, {"Cross-Selling.185", Int64.Type}, {"Cross-Selling.186", Int64.Type}, {"Cross-Selling.187", Int64.Type}, {"Cross-Selling.188", Int64.Type}, {"Cross-Selling.189", Int64.Type}, {"Cross-Selling.190", Int64.Type}, {"Cross-Selling.191", Int64.Type}, {"Cross-Selling.192", Int64.Type}, {"Cross-Selling.193", Int64.Type}, {"Cross-Selling.194", Int64.Type}, {"Cross-Selling.195", Int64.Type}, {"Cross-Selling.196", Int64.Type}, {"Cross-Selling.197", Int64.Type}, {"Cross-Selling.198", Int64.Type}, {"Cross-Selling.199", Int64.Type}, {"Cross-Selling.200", Int64.Type}, {"Cross-Selling.201", Int64.Type}, {"Cross-Selling.202", Int64.Type}, {"Cross-Selling.203", Int64.Type}, {"Cross-Selling.204", Int64.Type}, {"Cross-Selling.205", Int64.Type}, {"Cross-Selling.206", Int64.Type}, {"Cross-Selling.207", Int64.Type}, {"Cross-Selling.208", Int64.Type}, {"Cross-Selling.209", Int64.Type}, {"Cross-Selling.210", Int64.Type}, {"Cross-Selling.211", Int64.Type}, {"Cross-Selling.212", Int64.Type}, {"Cross-Selling.213", Int64.Type}, {"Cross-Selling.214", Int64.Type}, {"Cross-Selling.215", Int64.Type}, {"Cross-Selling.216", Int64.Type}, {"Cross-Selling.217", Int64.Type}, {"Cross-Selling.218", Int64.Type}, {"Cross-Selling.219", Int64.Type}, {"Cross-Selling.220", Int64.Type}, {"Cross-Selling.221", Int64.Type}, {"Cross-Selling.222", Int64.Type}, {"Cross-Selling.223", Int64.Type}, {"Cross-Selling.224", Int64.Type}, {"Cross-Selling.225", Int64.Type}, {"Cross-Selling.226", Int64.Type}, {"Cross-Selling.227", Int64.Type}, {"Cross-Selling.228", Int64.Type}, {"Cross-Selling.229", Int64.Type}, {"Cross-Selling.230", Int64.Type}, {"Cross-Selling.231", Int64.Type}, {"Cross-Selling.232", Int64.Type}, {"Cross-Selling.233", Int64.Type}, {"Cross-Selling.234", Int64.Type}, {"Cross-Selling.235", Int64.Type}, {"Cross-Selling.236", Int64.Type}, {"Cross-Selling.237", Int64.Type}, {"Cross-Selling.238", Int64.Type}, {"Cross-Selling.239", Int64.Type}, {"Cross-Selling.240", Int64.Type}, {"Cross-Selling.241", Int64.Type}, {"Cross-Selling.242", Int64.Type}, {"Cross-Selling.243", Int64.Type}, {"Cross-Selling.244", Int64.Type}, {"Cross-Selling.245", Int64.Type}, {"Cross-Selling.246", Int64.Type}, {"Cross-Selling.247", Int64.Type}, {"Cross-Selling.248", Int64.Type}, {"Cross-Selling.249", Int64.Type}, {"Cross-Selling.250", Int64.Type}, {"Cross-Selling.251", Int64.Type}, {"Cross-Selling.252", Int64.Type}, {"Cross-Selling.253", Int64.Type}, {"Cross-Selling.254", Int64.Type}, {"Cross-Selling.255", Int64.Type}, {"Cross-Selling.256", Int64.Type}, {"Cross-Selling.257", Int64.Type}, {"Cross-Selling.258", Int64.Type}, {"Cross-Selling.259", Int64.Type}, {"Cross-Selling.260", Int64.Type}, {"Cross-Selling.261", Int64.Type}, {"Cross-Selling.262", Int64.Type}, {"Cross-Selling.263", Int64.Type}, {"Cross-Selling.264", Int64.Type}, {"Cross-Selling.265", Int64.Type}, {"Cross-Selling.266", Int64.Type}, {"Cross-Selling.267", Int64.Type}, {"Cross-Selling.268", Int64.Type}, {"Cross-Selling.269", Int64.Type}, {"Cross-Selling.270", Int64.Type}, {"Cross-Selling.271", Int64.Type}, {"Cross-Selling.272", Int64.Type}, {"Cross-Selling.273", Int64.Type}, {"Cross-Selling.274", Int64.Type}, {"Cross-Selling.275", Int64.Type}, {"Cross-Selling.276", Int64.Type}, {"Cross-Selling.277", Int64.Type}, {"Cross-Selling.278", Int64.Type}, {"Cross-Selling.279", Int64.Type}, {"Cross-Selling.280", Int64.Type}, {"Cross-Selling.281", Int64.Type}, {"Cross-Selling.282", Int64.Type}, {"Cross-Selling.283", Int64.Type}, {"Cross-Selling.284", Int64.Type}, {"Cross-Selling.285", Int64.Type}, {"Cross-Selling.286", Int64.Type}, {"Cross-Selling.287", Int64.Type}, {"Cross-Selling.288", Int64.Type}, {"Cross-Selling.289", Int64.Type}, {"Cross-Selling.290", Int64.Type}, {"Cross-Selling.291", Int64.Type}, {"Cross-Selling.292", Int64.Type}, {"Cross-Selling.293", Int64.Type}, {"Cross-Selling.294", Int64.Type}, {"Cross-Selling.295", Int64.Type}, {"Cross-Selling.296", Int64.Type}, {"Cross-Selling.297", Int64.Type}, {"Cross-Selling.298", Int64.Type}, {"Cross-Selling.299", Int64.Type}, {"Cross-Selling.300", Int64.Type}, {"Cross-Selling.301", Int64.Type}, {"Cross-Selling.302", Int64.Type}, {"Cross-Selling.303", Int64.Type}, {"Cross-Selling.304", Int64.Type}, {"Cross-Selling.305", Int64.Type}, {"Cross-Selling.306", Int64.Type}, {"Cross-Selling.307", Int64.Type}, {"Cross-Selling.308", Int64.Type}, {"Cross-Selling.309", Int64.Type}, {"Cross-Selling.310", Int64.Type}, {"Cross-Selling.311", Int64.Type}, {"Cross-Selling.312", Int64.Type}, {"Cross-Selling.313", Int64.Type}, {"Cross-Selling.314", Int64.Type}, {"Cross-Selling.315", Int64.Type}, {"Cross-Selling.316", Int64.Type}, {"Cross-Selling.317", Int64.Type}, {"Cross-Selling.318", Int64.Type}, {"Cross-Selling.319", Int64.Type}, {"Cross-Selling.320", Int64.Type}, {"Cross-Selling.321", Int64.Type}, {"Cross-Selling.322", Int64.Type}, {"Cross-Selling.323", Int64.Type}, {"Cross-Selling.324", Int64.Type}, {"Cross-Selling.325", Int64.Type}, {"Cross-Selling.326", Int64.Type}, {"Cross-Selling.327", Int64.Type}, {"Cross-Selling.328", Int64.Type}, {"Cross-Selling.329", Int64.Type}, {"Cross-Selling.330", Int64.Type}, {"Cross-Selling.331", Int64.Type}, {"Cross-Selling.332", Int64.Type}, {"Cross-Selling.333", Int64.Type}, {"Cross-Selling.334", Int64.Type}, {"Cross-Selling.335", Int64.Type}, {"Cross-Selling.336", Int64.Type}, {"Cross-Selling.337", Int64.Type}, {"Cross-Selling.338", Int64.Type}, {"Cross-Selling.339", Int64.Type}, {"Cross-Selling.340", Int64.Type}, {"Cross-Selling.341", Int64.Type}, {"Cross-Selling.342", Int64.Type}, {"Cross-Selling.343", Int64.Type}, {"Cross-Selling.344", Int64.Type}, {"Cross-Selling.345", Int64.Type}, {"Cross-Selling.346", Int64.Type}, {"Cross-Selling.347", Int64.Type}, {"Cross-Selling.348", Int64.Type}, {"Cross-Selling.349", Int64.Type}, {"Cross-Selling.350", Int64.Type}, {"Cross-Selling.351", Int64.Type}, {"Cross-Selling.352", Int64.Type}, {"Cross-Selling.353", Int64.Type}, {"Cross-Selling.354", Int64.Type}, {"Cross-Selling.355", Int64.Type}, {"Cross-Selling.356", Int64.Type}, {"Cross-Selling.357", Int64.Type}, {"Cross-Selling.358", Int64.Type}, {"Cross-Selling.359", Int64.Type}, {"Cross-Selling.360", Int64.Type}, {"Cross-Selling.361", Int64.Type}, {"Cross-Selling.362", Int64.Type}, {"Cross-Selling.363", Int64.Type}, {"Cross-Selling.364", Int64.Type}, {"Cross-Selling.365", Int64.Type}, {"Cross-Selling.366", Int64.Type}, {"Cross-Selling.367", Int64.Type}, {"Cross-Selling.368", Int64.Type}, {"Cross-Selling.369", Int64.Type}, {"Cross-Selling.370", Int64.Type}, {"Cross-Selling.371", Int64.Type}, {"Cross-Selling.372", Int64.Type}, {"Cross-Selling.373", Int64.Type}, {"Cross-Selling.374", Int64.Type}, {"Cross-Selling.375", Int64.Type}, {"Cross-Selling.376", Int64.Type}, {"Cross-Selling.377", Int64.Type}, {"Cross-Selling.378", Int64.Type}, {"Cross-Selling.379", Int64.Type}, {"Cross-Selling.380", Int64.Type}, {"Cross-Selling.381", Int64.Type}, {"Cross-Selling.382", Int64.Type}, {"Cross-Selling.383", Int64.Type}, {"Cross-Selling.384", Int64.Type}, {"Cross-Selling.385", Int64.Type}, {"Cross-Selling.386", Int64.Type}, {"Cross-Selling.387", Int64.Type}, {"Cross-Selling.388", Int64.Type}, {"Cross-Selling.389", Int64.Type}, {"Cross-Selling.390", Int64.Type}, {"Cross-Selling.391", Int64.Type}, {"Cross-Selling.392", Int64.Type}, {"Cross-Selling.393", Int64.Type}, {"Cross-Selling.394", Int64.Type}, {"Cross-Selling.395", Int64.Type}, {"Cross-Selling.396", Int64.Type}, {"Cross-Selling.397", Int64.Type}, {"Cross-Selling.398", Int64.Type}, {"Cross-Selling.399", Int64.Type}, {"Cross-Selling.400", Int64.Type}, {"Cross-Selling.401", Int64.Type}, {"Cross-Selling.402", Int64.Type}, {"Cross-Selling.403", Int64.Type}, {"Cross-Selling.404", Int64.Type}, {"Cross-Selling.405", Int64.Type}, {"Cross-Selling.406", Int64.Type}, {"Cross-Selling.407", Int64.Type}, {"Cross-Selling.408", Int64.Type}, {"Cross-Selling.409", Int64.Type}, {"Cross-Selling.410", Int64.Type}, {"Cross-Selling.411", Int64.Type}, {"Cross-Selling.412", Int64.Type}, {"Cross-Selling.413", Int64.Type}, {"Cross-Selling.414", Int64.Type}, {"Cross-Selling.415", Int64.Type}, {"Cross-Selling.416", Int64.Type}, {"Cross-Selling.417", Int64.Type}, {"Cross-Selling.418", Int64.Type}, {"Cross-Selling.419", Int64.Type}, {"Cross-Selling.420", Int64.Type}, {"Cross-Selling.421", Int64.Type}, {"Cross-Selling.422", Int64.Type}, {"Cross-Selling.423", Int64.Type}, {"Cross-Selling.424", Int64.Type}, {"Cross-Selling.425", Int64.Type}, {"Cross-Selling.426", Int64.Type}, {"Cross-Selling.427", Int64.Type}, {"Cross-Selling.428", Int64.Type}, {"Cross-Selling.429", Int64.Type}, {"Cross-Selling.430", Int64.Type}, {"Cross-Selling.431", Int64.Type}, {"Cross-Selling.432", Int64.Type}, {"Cross-Selling.433", Int64.Type}, {"Cross-Selling.434", Int64.Type}, {"Cross-Selling.435", Int64.Type}, {"Cross-Selling.436", Int64.Type}, {"Cross-Selling.437", Int64.Type}, {"Cross-Selling.438", Int64.Type}, {"Cross-Selling.439", Int64.Type}, {"Cross-Selling.440", Int64.Type}, {"Cross-Selling.441", Int64.Type}, {"Cross-Selling.442", Int64.Type}, {"Cross-Selling.443", Int64.Type}, {"Cross-Selling.444", Int64.Type}, {"Cross-Selling.445", Int64.Type}, {"Cross-Selling.446", Int64.Type}, {"Cross-Selling.447", Int64.Type}, {"Cross-Selling.448", Int64.Type}, {"Cross-Selling.449", Int64.Type}, {"Cross-Selling.450", Int64.Type}, {"Cross-Selling.451", Int64.Type}, {"Cross-Selling.452", Int64.Type}, {"Cross-Selling.453", Int64.Type}, {"Cross-Selling.454", Int64.Type}, {"Cross-Selling.455", Int64.Type}, {"Cross-Selling.456", Int64.Type}, {"Cross-Selling.457", Int64.Type}, {"Cross-Selling.458", Int64.Type}, {"Cross-Selling.459", Int64.Type}, {"Cross-Selling.460", Int64.Type}, {"Cross-Selling.461", Int64.Type}, {"Cross-Selling.462", Int64.Type}, {"Cross-Selling.463", Int64.Type}, {"Cross-Selling.464", Int64.Type}, {"Cross-Selling.465", Int64.Type}, {"Cross-Selling.466", Int64.Type}, {"Cross-Selling.467", Int64.Type}, {"Cross-Selling.468", Int64.Type}, {"Cross-Selling.469", Int64.Type}, {"Cross-Selling.470", Int64.Type}, {"Cross-Selling.471", Int64.Type}, {"Cross-Selling.472", Int64.Type}, {"Cross-Selling.473", Int64.Type}, {"Cross-Selling.474", Int64.Type}, {"Cross-Selling.475", Int64.Type}, {"Cross-Selling.476", Int64.Type}, {"Cross-Selling.477", Int64.Type}, {"Cross-Selling.478", Int64.Type}, {"Cross-Selling.479", Int64.Type}, {"Cross-Selling.480", Int64.Type}, {"Cross-Selling.481", Int64.Type}, {"Cross-Selling.482", Int64.Type}, {"Cross-Selling.483", Int64.Type}, {"Cross-Selling.484", Int64.Type}, {"Cross-Selling.485", Int64.Type}, {"Cross-Selling.486", Int64.Type}, {"Cross-Selling.487", Int64.Type}, {"Cross-Selling.488", Int64.Type}, {"Cross-Selling.489", Int64.Type}, {"Cross-Selling.490", Int64.Type}, {"Cross-Selling.491", Int64.Type}, {"Cross-Selling.492", Int64.Type}, {"Cross-Selling.493", Int64.Type}, {"Cross-Selling.494", Int64.Type}, {"Cross-Selling.495", Int64.Type}, {"Cross-Selling.496", Int64.Type}, {"Cross-Selling.497", Int64.Type}, {"Cross-Selling.498", Int64.Type}, {"Cross-Selling.499", Int64.Type}, {"Cross-Selling.500", Int64.Type}, {"Cross-Selling.501", Int64.Type}, {"Cross-Selling.502", Int64.Type}, {"Cross-Selling.503", Int64.Type}, {"Cross-Selling.504", Int64.Type}, {"Cross-Selling.505", Int64.Type}, {"Cross-Selling.506", Int64.Type}, {"Cross-Selling.507", Int64.Type}, {"Cross-Selling.508", Int64.Type}, {"Cross-Selling.509", Int64.Type}, {"Cross-Selling.510", Int64.Type}, {"Cross-Selling.511", Int64.Type}, {"Cross-Selling.512", Int64.Type}, {"Cross-Selling.513", Int64.Type}, {"Cross-Selling.514", Int64.Type}, {"Cross-Selling.515", Int64.Type}, {"Cross-Selling.516", Int64.Type}, {"Cross-Selling.517", Int64.Type}, {"Cross-Selling.518", Int64.Type}, {"Cross-Selling.519", Int64.Type}, {"Cross-Selling.520", Int64.Type}, {"Cross-Selling.521", Int64.Type}, {"Cross-Selling.522", Int64.Type}, {"Cross-Selling.523", Int64.Type}, {"Cross-Selling.524", Int64.Type}, {"Cross-Selling.525", Int64.Type}, {"Cross-Selling.526", Int64.Type}, {"Cross-Selling.527", Int64.Type}, {"Cross-Selling.528", Int64.Type}, {"Cross-Selling.529", Int64.Type}, {"Cross-Selling.530", Int64.Type}, {"Cross-Selling.531", Int64.Type}, {"Cross-Selling.532", Int64.Type}, {"Cross-Selling.533", Int64.Type}, {"Cross-Selling.534", Int64.Type}, {"Cross-Selling.535", Int64.Type}, {"Cross-Selling.536", Int64.Type}, {"Cross-Selling.537", Int64.Type}, {"Cross-Selling.538", Int64.Type}, {"Cross-Selling.539", Int64.Type}, {"Cross-Selling.540", Int64.Type}, {"Cross-Selling.541", Int64.Type}, {"Cross-Selling.542", Int64.Type}, {"Cross-Selling.543", Int64.Type}, {"Cross-Selling.544", Int64.Type}, {"Cross-Selling.545", Int64.Type}, {"Cross-Selling.546", Int64.Type}, {"Cross-Selling.547", Int64.Type}, {"Cross-Selling.548", Int64.Type}, {"Cross-Selling.549", Int64.Type}, {"Cross-Selling.550", Int64.Type}, {"Cross-Selling.551", Int64.Type}, {"Cross-Selling.552", Int64.Type}, {"Cross-Selling.553", Int64.Type}, {"Cross-Selling.554", Int64.Type}, {"Cross-Selling.555", Int64.Type}, {"Cross-Selling.556", Int64.Type}, {"Cross-Selling.557", Int64.Type}, {"Cross-Selling.558", Int64.Type}, {"Cross-Selling.559", Int64.Type}, {"Cross-Selling.560", Int64.Type}, {"Cross-Selling.561", Int64.Type}, {"Cross-Selling.562", Int64.Type}, {"Cross-Selling.563", Int64.Type}, {"Cross-Selling.564", Int64.Type}, {"Cross-Selling.565", Int64.Type}, {"Cross-Selling.566", Int64.Type}, {"Cross-Selling.567", Int64.Type}, {"Cross-Selling.568", Int64.Type}, {"Cross-Selling.569", Int64.Type}, {"Cross-Selling.570", Int64.Type}, {"Cross-Selling.571", Int64.Type}, {"Cross-Selling.572", Int64.Type}, {"Cross-Selling.573", Int64.Type}, {"Cross-Selling.574", Int64.Type}, {"Cross-Selling.575", Int64.Type}, {"Cross-Selling.576", Int64.Type}, {"Cross-Selling.577", Int64.Type}, {"Cross-Selling.578", Int64.Type}, {"Cross-Selling.579", Int64.Type}, {"Cross-Selling.580", Int64.Type}, {"Cross-Selling.581", Int64.Type}, {"Cross-Selling.582", Int64.Type}, {"Cross-Selling.583", Int64.Type}, {"Cross-Selling.584", Int64.Type}, {"Cross-Selling.585", Int64.Type}, {"Cross-Selling.586", Int64.Type}, {"Cross-Selling.587", Int64.Type}, {"Cross-Selling.588", Int64.Type}, {"Cross-Selling.589", Int64.Type}, {"Cross-Selling.590", Int64.Type}, {"Cross-Selling.591", Int64.Type}, {"Cross-Selling.592", Int64.Type}, {"Cross-Selling.593", Int64.Type}, {"Cross-Selling.594", Int64.Type}, {"Cross-Selling.595", Int64.Type}, {"Cross-Selling.596", Int64.Type}, {"Cross-Selling.597", Int64.Type}, {"Cross-Selling.598", Int64.Type}, {"Cross-Selling.599", Int64.Type}, {"Cross-Selling.600", Int64.Type}, {"Cross-Selling.601", Int64.Type}, {"Cross-Selling.602", Int64.Type}, {"Cross-Selling.603", Int64.Type}, {"Cross-Selling.604", Int64.Type}, {"Cross-Selling.605", Int64.Type}, {"Cross-Selling.606", Int64.Type}, {"Cross-Selling.607", Int64.Type}, {"Cross-Selling.608", Int64.Type}, {"Cross-Selling.609", Int64.Type}, {"Cross-Selling.610", Int64.Type}, {"Cross-Selling.611", Int64.Type}, {"Cross-Selling.612", Int64.Type}, {"Cross-Selling.613", Int64.Type}, {"Cross-Selling.614", Int64.Type}, {"Cross-Selling.615", Int64.Type}, {"Cross-Selling.616", Int64.Type}, {"Cross-Selling.617", Int64.Type}, {"Cross-Selling.618", Int64.Type}, {"Cross-Selling.619", Int64.Type}, {"Cross-Selling.620", Int64.Type}, {"Cross-Selling.621", Int64.Type}, {"Cross-Selling.622", Int64.Type}, {"Cross-Selling.623", Int64.Type}, {"Cross-Selling.624", Int64.Type}, {"Cross-Selling.625", Int64.Type}, {"Cross-Selling.626", Int64.Type}, {"Cross-Selling.627", Int64.Type}, {"Cross-Selling.628", Int64.Type}, {"Cross-Selling.629", Int64.Type}, {"Cross-Selling.630", Int64.Type}, {"Cross-Selling.631", Int64.Type}, {"Cross-Selling.632", Int64.Type}, {"Cross-Selling.633", Int64.Type}, {"Cross-Selling.634", Int64.Type}, {"Cross-Selling.635", Int64.Type}, {"Cross-Selling.636", Int64.Type}, {"Cross-Selling.637", Int64.Type}, {"Cross-Selling.638", Int64.Type}, {"Cross-Selling.639", Int64.Type}, {"Cross-Selling.640", Int64.Type}, {"Cross-Selling.641", Int64.Type}, {"Cross-Selling.642", Int64.Type}, {"Cross-Selling.643", Int64.Type}, {"Cross-Selling.644", Int64.Type}, {"Cross-Selling.645", Int64.Type}, {"Cross-Selling.646", Int64.Type}, {"Cross-Selling.647", Int64.Type}, {"Cross-Selling.648", Int64.Type}, {"Cross-Selling.649", Int64.Type}, {"Cross-Selling.650", Int64.Type}, {"Cross-Selling.651", Int64.Type}, {"Cross-Selling.652", Int64.Type}, {"Cross-Selling.653", Int64.Type}, {"Cross-Selling.654", Int64.Type}, {"Cross-Selling.655", Int64.Type}, {"Cross-Selling.656", Int64.Type}, {"Cross-Selling.657", Int64.Type}, {"Cross-Selling.658", Int64.Type}, {"Cross-Selling.659", Int64.Type}, {"Cross-Selling.660", Int64.Type}, {"Cross-Selling.661", Int64.Type}, {"Cross-Selling.662", Int64.Type}, {"Cross-Selling.663", Int64.Type}, {"Cross-Selling.664", Int64.Type}, {"Cross-Selling.665", Int64.Type}, {"Cross-Selling.666", Int64.Type}, {"Cross-Selling.667", Int64.Type}, {"Cross-Selling.668", Int64.Type}, {"Cross-Selling.669", Int64.Type}, {"Cross-Selling.670", Int64.Type}, {"Cross-Selling.671", Int64.Type}, {"Cross-Selling.672", Int64.Type}, {"Cross-Selling.673", Int64.Type}, {"Cross-Selling.674", Int64.Type}, {"Cross-Selling.675", Int64.Type}, {"Cross-Selling.676", Int64.Type}, {"Cross-Selling.677", Int64.Type}, {"Cross-Selling.678", Int64.Type}, {"Cross-Selling.679", Int64.Type}, {"Cross-Selling.680", Int64.Type}, {"Cross-Selling.681", Int64.Type}, {"Cross-Selling.682", Int64.Type}, {"Cross-Selling.683", Int64.Type}, {"Cross-Selling.684", Int64.Type}}),
    #"Entpivotierte andere Spalten" = Table.UnpivotOtherColumns(#"Geänderter Typ1", {"Artikelnummer", "EAN"}, "Attribut", "Wert"),
    #"Zusammengeführte Abfragen" = Table.NestedJoin(#"Entpivotierte andere Spalten", {"Artikelnummer"}, Atikel_ID, {"Artikelnummer"}, "Atikel_ID", JoinKind.LeftOuter),
    #"Erweiterte Atikel_ID" = Table.ExpandTableColumn(#"Zusammengeführte Abfragen", "Atikel_ID", {"Artikel-ID"}, {"Artikel-ID"}),
    #"Entfernte Spalten" = Table.RemoveColumns(#"Erweiterte Atikel_ID",{"Wert"}),
    #"Geänderter Typ2" = Table.TransformColumnTypes(#"Entfernte Spalten",{{"Artikel-ID", type text}}),
    #"Gruppierte Zeilen" = Table.Group(#"Geänderter Typ2", {"Artikelnummer", "EAN"}, {{"ID", each Text.Combine([#"Artikel-ID"],","), type nullable text}})
in
    #"Gruppierte Zeilen"

Teil­weise gibt es in den Artikel-IDs kein Pen­dant zur Artikel­num­mer. Die Ergeb­niszellen enthal­ten dann den Inhalt null, welch­er in PQ prob­lem­los mit einem entsprechen­den Hin­weis erset­zt wer­den kann.

Nach­trag: Dem Fragesteller ging es wohl nicht schnell genug oder er fühlte sich im Her­ber-Forum nicht mehr wohl. Darum ist er weit­er gezo­gen, „natür­lich“ ohne „Nach­sendeantrag“; also mal wieder Cross­post­ing ohne Querver­weis. 🙁 Und hier ging es dann nach kurz­er Zeit auch weit­er:
https://www.clever-excel-forum.de/Thread-Suchen-Ersetzen-von-Suchbegriff-in-Zellen
Schade…

Und hier, beim Stich­wort last but not least find­en Sie noch einen Hin­weis, wo und wie Sie Antworten auf eventuelle Fra­gen oder auch die aus­gear­beit­ete Datei bekom­men kön­nen. Grundle­gen­des zum The­ma M-Code lesen Sie hier im Blog nach.