1 min readfrom Microsoft Excel | Help & Support with your Formula, Macro, and VBA problems | A Reddit Community

Power Query - ID and Service Plans are on different rows.

Hello,

I am new to Power Query, but I've run into a difficult situation involving multiple service plans attributed to a single customer ID. This is how my data comes in:

How the data comes in

I'd like it to look like this:

Desired result

I appreciate all help in advance!

submitted by /u/theguitargym
[link] [comments]

Want to read more?

Check out the full article on the original site

View original article

Tagged with

#Excel alternatives for data analysis
#big data management in spreadsheets
#generative AI for data analysis
#conversational data analysis
#rows.com
#real-time data collaboration
#intelligent data visualization
#self-service analytics tools
#Excel compatibility
#Power Query
#service plans
#customer ID
#data
#multiple service plans
#attributed
#desired result
#difficult situation
#different rows
#submitted by
#help