Forum Discussion
Helper IPower Query - Variable Row to Standardized Column Layout
Here is the solve on this. It's slightly modified from the desired table above as it does not have the placeholder Account columns but the respective Account columns are easily identifiable. The key is to merge the values columns by a unique delimliter, pivot, and split columns by same delimiter. Just have to think about data differently a bit.
Helper IThe layout has to be standardized regardless of the number of variable accounts for each name. Here is a truncated snapshot of the desired layout. Hope that helps.
Helper IHere is the solve on this. It's slightly modified from the desired table above as it does not have the placeholder Account columns but the respective Account columns are easily identifiable. The key is to merge the values columns by a unique delimliter, pivot, and split columns by same delimiter. Just have to think about data differently a bit.