{"__ref":"Forum:board:ExcelGeneral"},"parent":{"__ref":"ForumTopicMessage:message:4385509"},"conversation":{"__ref":"Conversation:conversation: another option without LAMBDA function: =LET(pp,TRANSPOSE(UNIQUE(p
","title":"Excel","shortTitle":"Excel","parent":{"__ref":"Category:category:microsoft365"},"ancestors":{"__typename":"CoreNodeConnection","edges":[{"__typename":"CoreNodeEdge","node":{"__ref":"Community:community:gxcuf89792"}},{"__typename":"CoreNod...
Solved: Hello! I am trying to combine Excel files in Powerquery that have different columns: The year will always change, and that bit I was able to
I am uncertain about the process of loading data from a web source and converting it to an Excel file. The source data has various columns, and I am specifically interested in saving the 'Open' column. What steps should I take to accomplish this task? import matplotlib.pyplot as plt impor...
combining Excel files with dfferent columns 03-17-2023 03:15 AM Hello! I am trying to combine Excel files in Powerquery that have different columns: The year will always change, and that bit I was able to somehow capture dynamically based on the column position (current year, next...
"subscribed":false,"board":{"__ref":"Forum:board:ExcelGeneral"},"conversation":{"__ref":"Conversation:conversation:3843532"},"subject":"Re: Assistance needed combining two text columns.","readOnly":false,"editFrozen":false,"moderationData":{"__ref":"ModerationData:moderation_data:3843570"...
Hello, I want to know if there is a way for me to combine two columns in a way that each cell on the first row is concatenated with each item of the...
Without knowing more information it is hard to help but assuming you are talking about combining two columns in Excel you can use the concatenate function. As an example, if you’d like to combine cell A1 and B1 into C1 separated by a space, using “=concat(A1,”“,B1)” in cell...
Hopefully that helps clarify things. If you would like to read up further,exceljetdoes a good job of explaining both functions with additional examples: TOROW:https://exceljet.net/functions/torow-function WRAPROWS:https://exceljet.net/functions/wraprows-function ...
Dear Forum Users, I have a question regarding fusing two lists of information in to one, i color coded them so it is clear where the information is...