•1 min read•from Microsoft Excel | Help & Support with your Formula, Macro, and VBA problems | A Reddit Community
Sorting and rearranging data using Pivot Table
I was given a task where I need to rearrange the Drawing ID in ascending order and in each drawing ID, there has its own no. of pieces (qty). I used chatgpt and it said to use Pivot Table. It was my first time using Pivot Table and I dont get the result I wanted.
It went well when summing up all the pieces for each drawing ID from different group no. But the drawing ID is not in its ascending order.
From the Pivot Table, the Drawing ID is not in ascending order.
Is Pivot Table the only way?
[link] [comments]
Want to read more?
Check out the full article on the original site
Tagged with
#Excel alternatives for data analysis
#generative AI for data analysis
#real-time data collaboration
#big data management in spreadsheets
#conversational data analysis
#rows.com
#intelligent data visualization
#data visualization tools
#enterprise data management
#big data performance
#data analysis tools
#data cleaning solutions
#natural language processing for spreadsheets
#Excel compatibility
#real-time collaboration
#Excel alternatives
#Pivot Table
#Drawing ID
#ascending order
#pieces