Notifications
Clear all
Power Query
2
Posts
2
Users
0
Reactions
24
Views
Topic starter
Hi,
I need assistance with data organization. I have two columns of data where invoice numbers and values are mingled. Could you please help me separate the invoice numbers and values into distinct columns? Additionally, I'd like to transpose the data for better analysis.
This topic was modified 8 hours ago by Md Saliha
Posted : 23/06/2025 3:21 pm
Don't understand. You highlighted one entry with multiple invoice numbers and one total value. Beside the table, you split the total into amounts by invoice. How would PQ/Excel know the individual invoice amounts if only the total is given?
Or do you mean that the individual invoice amounts are available in another table/list. If that is the case perhaps the query in the attached file helps you on your way.
Posted : 23/06/2025 7:39 pm
