Forum Discussion
split columns with null result
You need to figure out what you want and express it clearly. You also need to provide data examples that encompass the variability you might have, and what you really expect for results. In a previous post, you wrote: " would like to move the second line of transact column, up to line who contain the date. like that , i will get 2 value for the same date." How do you expect ot get 2 value for the same date in this new example? What do you really want for results?
what i am looking is: to put all values from Transact column who are under same previous date on the same line .
i dont know how to updalod an excel file to give you a realistic example .
But in your new example, you now have multiple Values for the same Date! In your original post, you only had a single Value for each Date. I'm afraid without examples of your expected output from you pictured input, I will not be able to assist you any further.
You keep changing the specifications with each post and I have no idea what you expect for output.
thank you and sorry for the confusion. you solution is good enough for me .
but if you could explain me what u did the second step ?
ronrsnfld wrote:But in your new example, you now have multiple Values for the same Date! In your original post, you only had a single Value for each Date. I'm afraid without examples of your expected output from you pictured input, I will not be able to assist you any further.
You keep changing the specifications with each post and I have no idea what you expect for output.
ronrsnfld wrote:But in your new example, you now have multiple Values for the same Date! In your original post, you only had a single Value for each Date. I'm afraid without examples of your expected output from you pictured input, I will not be able to assist you any further.
You keep changing the specifications with each post and I have no idea what you expect for output.
ronrsnfld wrote:But in your new example, you now have multiple Values for the same Date! In your original post, you only had a single Value for each Date. I'm afraid without examples of your expected output from you pictured input, I will not be able to assist you any further.
You keep changing the specifications with each post and I have no idea what you expect for output.
#"Add Shifted Transactions" = Table.FromColumns( {#"Changed Type"[date]} & {#"Changed Type"[transaction]} & {List.Skip(#"Changed Type"[transaction])} & {#"Changed Type"[value]}, type table[date=date, transaction.1=text, transaction.2=text, value=number]),That could also be written:
#"Add Shifted Transactions" = Table.FromColumns( Table.ToColumns(#"Changed Type") & {List.Skip(#"Changed Type"[transaction])}, type table[date=date, transaction.1=text, value=number, transaction.2=text]),It is creating List for each of the columns in the table, and then adding another column where we Skip the first entry in the transaction column (hence moving it up one).
Examine MS Help for those functions to better understand.
Doing it this way results in the transactions.2 column being the last column, so you need to re-arrange the columns to obtain the desired order.
In the initial code, I controlled the column order by entering each column individually, instead of adding all the original columns and then appending the shifted column.