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)...
Hi Max_Petti
This is doable in principal. Could you upload and share a sample workbook on OneDrive, Google Drive... and post the link here please?
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
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