Forum Discussion
Power query Editor - how to keep few cells in single row
Hi Team,
Please help me with the solution on keeping few cells data from below row in power query.
i want to delete null values from 2nd row till 9th column and rest as it is.
| 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 | 13 | 14 | 15 | 16 | 17 | 18 | 19 | 20 | 21 | 22 | 23 | 24 | 25 | 26 | 27 | 28 |
| Article ID | Article Desc | GTIN | Site ID | Site DESC | Vendor | Vendor Desc | Vendor Article No | DC Article Cost | Metrics | Inv Qty | Inv Qty | Inv Qty | Inv Qty | Inv Qty | Inv Qty | Inv Qty | Inv Qty | Inv Qty | Inv Qty | Inv Qty | Inv Qty | Inv Qty | |||||
| null | null | null | null | null | null | null | null | null | Cross Site Status | Nov-22 | Dec-22 | Jan-23 | Feb-23 | Mar-23 | Apr-23 | May-23 | Jun-23 | Jul-23 | Aug-23 | Sep-23 | Oct-23 | Nov-23 | 12Mth Invoiced Qty | SOH Total Qty | DC SOO Qty | SO Backorder Qty |
2 Replies
spinfuzerSolution Sage
I don't understand. What should it look afterwards? Do you mean you want to Table ReplaceValue null with blank so it shows whitespace instead of null?
ronrsnfldSuper User
Your statement doesn't make sense to me. If you delete a null value, what remains is a null.
Perhaps showing a few rows of original data and another table showing your desired results from that data would be useful clarifying what you really want.