Forum Discussion
Post ProdigyAdding columns
Hi Dicken,
Another interesting approach I could think of was this, thanks
Before Re-Ordering, to add more columns, two functions List.RemoveMatchingItems and List. Accumulate, here's howPost this, follow up with the Re-ordering given below
1. Extracting ColNames and Loading it to Excel
2. Adding a Order Number Column in Excel as per the order you'd like
3. Load this new data back into Power Query (here, that is Col Order)
4. Last stepm using the Order Number col, arrange the data in ascending or descending order5. Just use that query in the Table.ReorderColumns Function
Super UserHi Dicken,
Another interesting approach I could think of was this, thanks
Before Re-Ordering, to add more columns, two functions List.RemoveMatchingItems and List. Accumulate, here's how
Post this, follow up with the Re-ordering given below
1. Extracting ColNames and Loading it to Excel
2. Adding a Order Number Column in Excel as per the order you'd like
3. Load this new data back into Power Query (here, that is Col Order)
4. Last stepm using the Order Number col, arrange the data in ascending or descending order
5. Just use that query in the Table.ReorderColumns Function
DickenAn interesting approach, thanks, for the suggestion,
RD