Hi All,
I want to Add or Split custom column, with Power Query, which have mixed data type, based on condition that, if entry in cell have “Cr”, then it will go to added column with “-“ Sign.
Please suggest.
I want to Add or Split custom column, with Power Query, which have mixed data type, based on condition that, if entry in cell have “Cr”, then it will go to added column with “-“ Sign.
Please suggest.
Data Type (Mixed) Or Text | Data Type (decimal) | Data Type (decimal) | ||
Transaction | Debit | Credit | ||
158 | 158 | |||
112 Cr | -112 | |||
164 | 164 | |||
193 | 193 | |||
103 | 103 | |||
248 Cr | -248 | |||
221 | 221 | |||
69 | 69 | |||
90 | 90 |