Forum Discussion
Power Query Data Transposition Inquiry
Hello,
I am looking for suggestions on how to transform the following data set:
to the following table:
The data set deals with groups of clients (denoted in the first column); there can be more than 1 row of data per each group, and in some cases there are 15+ accounts/rows of data associated with a client group. I am hoping to combine all rows of data so each client group and corresponding address are reflected on a single row, with the corresponding account numbers (being the unique identifiers) being transposed.
Is this possible to accomplish via power query?
Sincerely,
Max
3 Replies
- Hey L.Z.
Appreciate the response. Currently I am unable to send any actual files whilst working under certain compliance parameters. However, I will let you know if this changes in the event that I would be able to deliver a sample file. I did however copy the sample data below if that is something you're able to work with in the interim.
Client Group Address City State 02210 Country Household Name Account #
1 1200 Flinstone Ave SAN ANTONIO TX 78209 US Smith Family 1234
2 518 Wizard's Way HOUSTON TX 77079 US Johnson Family 1235
2 519 Wizard's Way HOUSTON TX 77079 US Johnson Family 1236
2 520 Wizard's Way HOUSTON TX 77079 US Johnson Family 1237
4 903 Lover's Lane GALVESTON TX 77554 US Adams Family 1238
4 904 Lover's Lane GALVESTON TX 77554 US Adams Family 1239
4 905 Lover's Lane GALVESTON TX 77554 US Adams Family 1240
4 906 Lover's Lane GALVESTON TX 77554 US Adams Family 1241
Sincerely,
Max
